"the literal " (3410 / 428 / 2216)
'the literal ' (3910 / 478 / 2716)
\s*any whitespace character, repeated any number of times
SELECTthe literal text SELECT (case sensitive) Non-Capturing Group(?:\s+(?:(?!\1).)*)? ?repeats the group contents below at most once:
\s+any whitespace character, repeated at least once
Non-Capturing Group(?:(?!\1).)* *repeats the group contents below any number of times:
\1the text saved by group 1
.any character (except for line terminators)
\s+any whitespace character, repeated at least once
FROMthe literal text FROM (case sensitive) Non-Capturing Group(?:\s+(?:(?!\1).)*)? ?repeats the group contents below at most once:
\s+any whitespace character, repeated at least once
Non-Capturing Group(?:(?!\1).)* *repeats the group contents below any number of times:
\1the text saved by group 1
.any character (except for line terminators)
\1the text saved by group 1
Non-Capturing Group(?:[^\w]|$) Negated Character Class[^\w] 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