Regular Expressions 101

Community Patterns

update match

2

Regular Expression
PCRE (PHP <7.3)

/
(?i)UPDATE[ \t\n]{1,}(fact)(.*)\n(from)?([ \t\n]{1,})?(.*)?\n*set[ \n\t]{1,}(coloana)[ \t\n]*=[ \t\n]*(ifnull\(\s*)*([\w\d]*)([\ ,'\w\n\t)(\n=.]*);
/

Description

no description available

Submitted by ozarzu - 9 years ago