Regular Expressions 101

1st Alternative(>=|<=|'[^']*(?:''[^']*)*')

Group 1(>=|<=|'[^']*(?:''[^']*)*')

1st Alternative>=

>=the literal text >=

2nd Alternative<=

<=the literal text <=

3rd Alternative'[^']*(?:''[^']*)*'

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

Negated Character Class[^']*

*matches any number of characters outside the set below:

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

Non-Capturing Group(?:''[^']*)*

*repeats the group contents below any number of times:

''the literal text ''

Negated Character Class[^']*

*matches any number of characters outside the set below:

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

2nd Alternative=

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

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

(>=|<=|'[^']*(?:''[^']*)*')|=

New

select * from where item1=abcd and price>=20 and item1 = abc and title='strings=evil''bugs' and id=-197