import re
regex = re.compile(r"(comment_approved\s=\s\'(?:1|0)\')|\(\s(comment_approved\s=\s'0'\sOR\scomment_approved\s=\s'1')\s\)")
test_str = ("( 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' )\n")
subst = "( $1$2 OR comment_approved = \\'trash\\' )"
result = regex.sub(subst, test_str, count=1)
if result:
print(result)
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Python, please visit: https://docs.python.org/3/library/re.html