Please enable JavaScript to use this web application.
Regular
Expressions
101
Social
Social
Join the Discord community!
Follow me on twitter!
Send me an email
Donate
Donate
Donate through Paypal
Become a Github Sponsor
Info
Info
Find out what's new!
RegEx101 Wiki
Report bugs or make suggestions
What's new?
Loading content...
Close
Regex Editor
Regex Editor
Community Patterns
Community Patterns
Account
Account
Regex Quiz
Regex Quiz
Settings
Settings
Live Help
Live Help
Get help on Discord
Get help on IRC
Order By
Most Recent
Highest Score
Lowest Score
Most upvotes
Most downvotes
Filter by Flavor
PCRE2 (PHP >=7.3)
PCRE (PHP <7.3)
ECMAScript (JavaScript)
Python
Golang
Java 8
.NET (C#)
Rust
Sponsors
Community Patterns
Search among 12,580 community submitted regex patterns...
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
NCAA EPG - CRACKSTREAMS
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-15 08:44
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Product Description
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 07:55
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
sql default constraints
PCRE (PHP <7.3)
Search in sql script generated using SCA for the implicit constraint names and defining the name explicityly
Submitted by
anonymous
-
4 years ago
2019-09-16 08:30
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
sql default constraints
PCRE (PHP <7.3)
Search in sql script generated using SCA for the implicit constraint names and defining the name explicityly
Submitted by
anonymous
-
4 years ago
2019-09-16 08:38
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Extract endpoint from url
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 12:25
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
XML Containers
PCRE (PHP <7.3)
For stripping containers and leaving elements from an XML Message
Submitted by
anonymous
-
4 years ago
2019-09-16 13:09
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Namespace Declaration
ECMAScript (JavaScript)
like xxx="something" in
Submitted by
anonymous
-
4 years ago
2019-09-16 13:11
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
jdbc connection parse
PCRE (PHP <7.3)
Made for HSY
Submitted by
anonymous
-
4 years ago
2019-09-16 15:59
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
1
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 16:31
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
2
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 16:31
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
3
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 16:31
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Drop down list selector
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 17:30
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
YouTube Video ID Selection
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 17:33
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
codigos_mipres
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-16 21:31
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Find file name in list of files read with "rb" (as bytes)
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-17 00:33
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Grade
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-19 09:58
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Duplicate tier test
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-17 13:50
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Kentekens
PCRE (PHP <7.3)
https://regex101.com/r/JA7gRt/5
Submitted by
anonymous
-
4 years ago
2019-09-17 14:46
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Portugal / Portuguese License Plate (Matrícula - Placa)
ECMAScript (JavaScript)
Regex to recognize Vehicle License Plates in Portugal
Submitted by
anonymous
-
4 years ago
2019-09-18 10:34
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
French License Plate / Plaque Immatriculation en France
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
4 years ago
2019-09-18 10:38
1
...
531
532
533
534
535
536
537
...
629
Extracts table names from SELECT query
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Regular Expression
PCRE (PHP <7.3)
/
(?<=
FROM
|
JOIN
|
OJ
)
[
\s
\(
]
+
(
(
(
(?!
SELECT
\b
)
`
?
[
\w
_
]
+
`
?
)
(
\s
*
\)
?
,
\s
*
)*
)+
)
/
gi
Open regex in editor
Description
Loading markdown...
Submitted by
Mykhaylo Khodorev (mykhaylo.khodorev@gmail.com)
-
7 years ago
2016-05-29 22:34