Regular Expressions 101

1st Alternative(comment_approved\s=\s\'(?:1|0)\')

Group 1(comment_approved\s=\s\'(?:1|0)\')

comment_approvedthe literal text comment_approved (case sensitive)

\sany whitespace character

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

\sany whitespace character

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

Non-Capturing Group(?:1|0)

1st Alternative1

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

2nd Alternative0

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

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

2nd Alternative\(\s(comment_approved\s=\s'0'\sOR\scomment_approved\s=\s'1')\s\)

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

\sany whitespace character

Group 2(comment_approved\s=\s'0'\sOR\scomment_approved\s=\s'1')

comment_approvedthe literal text comment_approved (case sensitive)

\sany whitespace character

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

\sany whitespace character

'0'the literal text '0'

\sany whitespace character

ORthe literal text OR (case sensitive)

\sany whitespace character

comment_approvedthe literal text comment_approved (case sensitive)

\sany whitespace character

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

\sany whitespace character

'1'the literal text '1'

\sany whitespace character

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(comment_approved\s=\s\'(?:1|0)\')|\(\s(comment_approved\s=\s'0'\sOR\scomment_approved\s=\s'1')\s\)

New

( comment_approved = '0' OR comment_approved = '1' ) AND ( (CAST(wp_72423799_commentmeta.meta_value AS SIGNED) >= '1409095998') ) AND (wp_72423799_commentmeta.meta_key = 'o2_comment_gmt_modified' )

Substitution

( $1$2 OR comment_approved = \'trash\' )