Regular Expressions 101

Pro

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Negative Lookahead(?!\s*SELECT\b)

\s*any whitespace character, repeated any number of times

SELECTthe literal text SELECT (case sensitive)

\ban ASCII word boundary

Negated Character Class[^()]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

\((?!\s*SELECT\b)[^()]*\)

New

WITH test AS (
    SELECT
        DATE_DIFF(start_date, end_date, DAY),
        DATE_DIFF(start_date
                  ,end_date
                  ,DAY)
    FROM apple
)
,test 2 AS (
    SELECT blah
    FROM blah
)
SELECT
    *
FROM test