Regular Expressions 101

Positive Lookbehind(?<=\bfrom\b)

\ban ASCII word boundary

fromthe literal text from (case sensitive)

\ban ASCII word boundary

Negative Lookahead(?!\s*#)

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

#the literal # (35₁₀ / 43₈ / 23₁₆)

Group 1([^w]*(?:\bw(?!here\b)[^w]*)*)

Negated Character Class[^w]*

*matches any number of characters outside the set below:

wthe literal w (119₁₀ / 167₈ / 77₁₆) (case sensitive)

Non-Capturing Group(?:\bw(?!here\b)[^w]*)*

*repeats the group contents below any number of times:

\ban ASCII word boundary

wthe literal w (119₁₀ / 167₈ / 77₁₆) (case sensitive)

Negative Lookahead(?!here\b)

herethe literal text here (case sensitive)

\ban ASCII word boundary

Negated Character Class[^w]*

*matches any number of characters outside the set below:

wthe literal w (119₁₀ / 167₈ / 77₁₆) (case sensitive)

Positive Lookahead(?=\bwhere\b)

\ban ASCII word boundary

wherethe literal text where (case sensitive)

\ban ASCII word boundary

Global pattern flags

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?<=\bfrom\b)(?!\s*#)([^w]*(?:\bw(?!here\b)[^w]*)*)(?=\bwhere\b)

New

select ... from course c
where id = (select ... from student where ...)
select ... from #bar
where id = (select ... from student where ...)