Regular Expressions 101

SELECT the literal text SELECT (case sensitive)

Character Class[\w\s$\*$\,]*

*matches any number of characters from the set below:

\wany word character

\sany whitespace character

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

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

\,the literal , (44₁₀ / 54₈ / 2C₁₆)

FROM ticket_file the literal text FROM ticket_file (case sensitive)

Character Class[\w\s\"\'\`\<\>\=]*

*matches any number of characters from the set below:

\wany word character

\sany whitespace character

\"the literal " (34₁₀ / 42₈ / 22₁₆)

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

\`the literal ` (96₁₀ / 140₈ / 60₁₆)

\<the literal < (60₁₀ / 74₈ / 3C₁₆)

\>the literal > (62₁₀ / 76₈ / 3E₁₆)

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

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

SELECT [\w\s\(\*\)\,]* FROM ticket_file [\w\s\"\'\`\<\>\=]*

SELECT * FROM ticket_file WHERE 1

SELECT id, name FROM ticket_file WHERE id < 100

SELECT COUNT(*) FROM ticket_file

SELECT MAX(id) FROM ticket_file