Regular Expressions 101

Order By

Sponsors
There are currently no sponsors. Become a sponsor today!

Community Patterns

1

password8s

PCRE (PHP <7.3)
password con 8
Submitted by anonymous - 9 years ago
1

match non-regular words

PCRE (PHP <7.3)
no description available
Submitted by Jason - 9 years ago
1

email regex

ECMAScript (JavaScript)
no description available
Submitted by anonymous - 9 years ago
1

CSV : Match values with carriage return

PCRE (PHP <7.3)
Use with csv with ";" delim. Matches values that contains carriage return not surrounded by double quotes.
Submitted by anonymous - 9 years ago
1

Detects IPv4 and IPv6 addresses

PCRE (PHP <7.3)
This is loosely based on some other examples, but goes a bit further in terms of what it will and won't match. In particular, it matches IPv6 addresses like ff02::, ff02:1000::, and (the syntactically valid but improbable) ::0001:0002
Submitted by Alan - 9 years ago
1

Extracts table names from SELECT query

PCRE (PHP <7.3)
Finds table names in table list and subqueries. Table names are in group #1 of all matches One note. In case of table list (like SELECT * FROM table1, table2, etc) group#1 will contain all tables string (like "table1, table2, etc") so it's necessary to do additional handing like splitting the string
Submitted by Mykhaylo Khodorev (mykhaylo.khodorev@gmail.com) - 9 years ago
0

Line match

ECMAScript (JavaScript)
Regex to match any no of lines
Submitted by noby nirmal - 9 years ago
1

sentence regex

PCRE (PHP <7.3)
This regex will pick sentences.
Submitted by noby nirmal - 9 years ago
1

Bigger or lower than a number with <>

Python
no description available
Submitted by woss.io - 9 years ago
1

sentence checker

PCRE (PHP <7.3)
This will check for any no of strings
Submitted by noby nirmal - 9 years ago
1

Sentence checker

ECMAScript (JavaScript)
This will validate any nu of lines
Submitted by noby nirmal - 9 years ago
1

anime English title

Python
anime English title from snipertopanime
Submitted by Wasdee - 9 years ago
1

Find </a>

PCRE (PHP <7.3)
no description available
Submitted by Ivan Milazzotti - 9 years ago
1

Find specific tag content

PCRE (PHP <7.3)
no description available
Submitted by Ivan Milazzotti - 9 years ago
0

Validates argentinian telephone numbers

Python
To validate a number with this regular expression is mandatory to have the number group with only digits. You can modify the number group to accept spaces, hyphens, and dots with something like this: (?P[\d\-\.]+). Valid examples +54 9 11 50165564 54 2268 201232 15 50165564...
Submitted by Agustín Bouillet - 9 years ago
1

Wikipedia parse

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 9 years ago
1

Extracts table names from SELECT query

PCRE (PHP <7.3)
Finds table names in table list and subqueries. Table names are in group #1 of all matches One note. In case of table list (like SELECT * FROM table1, table2, etc) group#1 will contain all tables string (like "table1, table2, etc"). In case of subquery in a table list group#1 may contain also other ...
Submitted by Mykhaylo Khodorev (mykhaylo.khodorev@gmail.com) - 9 years ago
1

auto-complete

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 9 years ago
1

matching+backreferencing method parameters

PCRE (PHP <7.3)
match a specific method name match a quoted double value for method parameter 1 match a quoted, specific string value for method parameter 2
Submitted by nickleus - 9 years ago
1

potential shell

PCRE (PHP <7.3)
Potential malware/sheel signature
Submitted by cedk / ced404 - 9 years ago
1...220221222223224...902

Community Library Entry

1

Regular Expression
PCRE (PHP <7.3)

/
(?<=FROM|JOIN|OJ)[\s\(]+((((?!SELECT\b)`?[\w_]+`?)(\s*\)?,\s*)*)+)
/
gi
Open regex in editor

Description

Finds table names in table list and subqueries. Table names are in group #1 of all matches One note. In case of table list (like SELECT * FROM table1, table2, etc) group#1 will contain all tables string (like "table1, table2, etc"). In case of subquery in a table list group#1 may contain also other symbols besides table names and commas (most likely - "(" ). So it's necessary to do additional handing like splitting the string.

Submitted by Mykhaylo Khodorev (mykhaylo.khodorev@gmail.com) - 9 years ago