Regular Expressions 101

Explanation

Pro

Group 1(or|and|(?:(?P<case1namE>)\() ?|)

1st Alternativeor

orthe literal text or (case insensitive)

2nd Alternativeand

andthe literal text and (case insensitive)

3rd Alternative(?:(?P<case1namE>)\() ?

Non-Capturing Group(?:(?P<case1namE>)\()

Group case1namE(?P<case1namE>) — does not consume characters

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

?optionally matches the literal (32₁₀ / 40₈ / 20₁₆)

4th Alternative — matches an empty string

?optionally matches the literal (32₁₀ / 40₈ / 20₁₆)

\w*any word character, repeated any number of times

Group 3(\.)?

?repeats the group contents below at most once:

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

colzthe literal text colz (case insensitive)

Group 4( like| ?\=)

1st Alternative like

likethe literal text like (case insensitive)

2nd Alternative ?\=

?optionally matches the literal (32₁₀ / 40₈ / 20₁₆)

\=the literal = (61₁₀ / 75₈ / 3D₁₆)

?optionally matches the literal (32₁₀ / 40₈ / 20₁₆)

\?the literal ? (63₁₀ / 77₈ / 3F₁₆)

Non-Capturing Group(?:(?P=case1namE) OR)?

?repeats the group contents below at most once:

(?P=case1namE)the text saved by group case1namE

ORthe literal text OR (case insensitive)

Group 5( and)?

?repeats the group contents below at most once:

andthe literal text and (case insensitive)

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

(or|and|(?:(?P<case1namE>)\() ?|) ?\w*(\.)?colz( like| ?\=) ?\?(?:(?P=case1namE) OR)?( and)?

New

technology=? AND tbl.colz = ?(notes.user_id like ? OR votes_count like ? OR notes.id like ?
OR notes.note like ? OR notes.link like ? OR notes.description like ? 
OR technology like ? OR notes.code_link like ? OR notes.priority like ? OR notes.created_at like ?
OR notes.updated_at like ? OR notes.technology_id = ? OR notes.user_id like ?)


//replace colz with any column name(ex: technology_id) and it should work just as expected

//this expression is to capture and remove "having" columns from query without any error

Extraction

technology=? AND tbl.colz = ?(notes.user_id like ? OR votes_count like ? OR notes.id like ?
OR notes.note like ? OR notes.link like ? OR notes.description like ? 
OR technology like ? OR notes.code_link like ? OR notes.priority like ? OR notes.created_at like ?
OR notes.updated_at like ? OR notes.technology_id = ? OR notes.user_id like ?)


//replace colz with any column name(ex: technology_id) and it should work just as expected

//this expression is to capture and remove "having" columns from query without any error