Regular Expressions 101

1st Alternative(\(1054, "Unknown column 'inf(e0)?' in 'field list'"\))(?# )

Group 1(\(1054, "Unknown column 'inf(e0)?' in 'field list'"\))

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

1054, "Unknown column 'infthe literal text 1054, "Unknown column 'inf (case sensitive)

Group 2(e0)?

?repeats the group contents below at most once:

e0the literal text e0 (case sensitive)

' in 'field list'"the literal text ' in 'field list'" (case sensitive)

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

Comment:

2nd Alternative(?# )(ProgrammingError: inf can not be used with MySQL)

Comment:

Group 3(ProgrammingError: inf can not be used with MySQL)

ProgrammingError: inf can not be used with MySQLthe literal text ProgrammingError: inf can not be used with MySQL (case sensitive)

Global pattern flags

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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

(\(1054, "Unknown column 'inf(e0)?' in 'field list'"\))(?#
)|(?#
)(ProgrammingError: inf can not be used with MySQL)

New

(1054, "Unknown column 'infe0' in 'field list'")
(1054, "Unknown column 'inf' in 'field list'")
ProgrammingError: inf can not be used with MySQL

(1054, "Unknown column 'infe0' in 'field list'")
(1054, "Unknown column 'inf' in 'field list'")
ProgrammingError: inf can not be used with MySQL