Please enable JavaScript to use this web application.
Regular
Expressions
101
Social
Donate
Info
Regex Editor
Community Patterns
Account
Regex Quiz
Settings
Order By
Most Recent
Most upvotes
Most downvotes
Highest Score
Lowest Score
Filter by Flavor
PCRE2 (PHP >=7.3)
PCRE (PHP <7.3)
ECMAScript (JavaScript)
Python
Golang
Java 8
.NET 7.0 (C#)
Rust
Sponsors
There are currently no sponsors.
Become a sponsor today!
Community Patterns
Search among 15,000 community submitted regex patterns...
There does not seem to be anything here
Community Library Entry
1
Regular Expression
PCRE2 (PHP >=7.3)
/
^
select
\s
+
(?<attr>
.
+
?
)
\s
+
from
\s
+
(?<name>
\S
+
)
\s
*
(?:
where
\s
+
(?<cnd>
[
\d\w
=
><!
]
+
)
)?
;
?
$
/
gmi
Open regex in editor
Description
/^select\s+(?<attr>.+?)\s+from\s+(?<name>\S+)\s*(?:where\s+(?<cnd>[\d\w= ><!]+))?;?$/gmi
Submitted by
anonymous
-
3 months ago