Regular Expressions 101

Library entries

0
pcre2

Barcode Regex

Barcode Regex
Submitted by anonymous - a year ago
1
pcre2

todos and tags in code

todos and tags in code
Submitted by anonymous - a year ago
0
pcre2

Note Body HTML

Match all valid HTML tags
Submitted by anonymous - a year ago
0
pcre2

scss class matching

scss class matching
Submitted by lucas - a year ago
0
pcre2

ipv4 match

ipv4 match
Submitted by anonymous - a year ago
0
pcre2

股票代码

aa
Submitted by vv - a year ago
0
pcre2

Get HTML attribute

Get HTML attribute with /" inside
Submitted by anonymous - a year ago
0
pcre2

IP address with port

Match ip address with port
Submitted by PARNKOT - a year ago

select

Vote

0

Regular Expression
pcre2

/
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?;))))?|((database|user|version)\(\));)
/
gm

Description

Loading markdown...
Submitted by lyf - a year ago