Regular Expressions 101

Pro

1st Alternative'\s*(?0)?[^']*'\K

'the literal ' (39₁₀ / 47₈ / 27₁₆)

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

(?0)?optionally recurses into the entire pattern

Negated Character Class[^']*

*matches any number of characters outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match

2nd Alternative(\w+)

Group 1(\w+)

\w+any word character, repeated at least once

Global pattern flags

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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

'\s*(?0)?[^']*'\K|(\w+)

New

SELECT column_name FROM table_name WHERE column_name IN ('A' , 'st9u' ,'Meyer', ....);
WHERE    a.object_type IN (' 'TABLE'', ''MATEerialIZED VIE3W'   ')