Regular Expressions 101

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Negative Lookahead(?!=)

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

.+any character (except for line terminators), repeated at least once

:the literal : (58₁₀ / 72₈ / 3A₁₆)

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

:(?!=).+:

Test String
New

SELECT name, @age:=(age+5), address, @total:=(total+1)
FROM `users`
WHERE
id = :id:
name = :LOWER(name):
date = :strftime('%Y-%m %H:%i:%s', updated_at):
hash = :MD5(concat(status, salt)):
desc = :hash=foo:
ORDER BY name ASC

SELECT mytable.id, DATE_FORMAT(mytable.created_at,'%d/%m/%Y %H:%i:%s') AS created_at_uk FROM mytable WHERE mytable.id = ?

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...