louis's Blog

With SQL, Day 1 Part 1, it’s almost too easy:

    SELECT SUM(CONCAT(REGEXP_SUBSTR(line, '[0-9]'),
                      REGEXP_SUBSTR(REVERSE(line), '[0-9]'))) AS num
    FROM day1_input;

#aoc2023 #day1 #sql #mysql

To like or reply, open original post on Emacs.ch