Regular Expressions 101

Sponsors

Library entries

0
pcre

Numeric

Regex to get any numeric string
Submitted by anonymous - 6 months ago
0
java

Email

Test e-amil
Submitted by uk - 6 months ago
0
pcre2

Date match on multiple formats

Date match on multiple formats
Submitted by anonymous - 6 months ago
0
pcre2

test

Testing for sharing
Submitted by me - 6 months ago
0
pcre2

拼音正则匹配

拼音正则匹配
Submitted by anonymous - 6 months ago
0
pcre2

Email

Email no Ñ no tilde
Submitted by anonymous - 6 months ago
0
pcre

facebook

AMP - chinatimes
Submitted by anonymous - 6 months ago

select

Vote

0

Regular Expression
java

"
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 - 9 months ago