Regular Expressions 101

Community Patterns

0

Address

PCRE2 (PHP >=7.3)
grab address
Submitted by anonymous - 3 years ago

select

0

Regular Expression
Java 8

"
select\s+(\*|((\w+(\.\w+)?)+(\s?,\s?\w+(\.\w+)?)*)|((\w+\([^\s]|(\w+\.\w+)?\))(\s+\,\s+)?)+)\s+from\s+(\w+(\s?,\s?\w+)*\;?)(\s+((\w+\s+join)\s+(\w+(\.\w)?\s+on\s+(\w+(\.\w+)?\s+=\s+\w+(\.\w+)?)?)(\s+,\s+)?)+)?(\s+((limit\s+(\w+)?\s?(\,\w+\;)?)|((where)?\s+?([^\;]+\s?;))))?
"
mg

Description

Loading markdown...
Submitted by anonymous - 2 years ago