Regular Expressions 101

Order By

Filter by Flavor

Community Patterns

Search among 120 community submitted regex patterns...

1...4 5 6

SQL Condition

Regular Expression
PCRE2 (PHP >=7.3)

((\s*\b([a-zA-Z_]*)\b)\s*((\s*=\s*(('[\w\-_#@,.!@#$%^&*()\s]*')))|((\s+\bLIKE\b\s+('[\w\-_#@,.!@#$%^&*()\s]*')))|(((\s+\bIN\b\s+$'[\w\-_#@,.!@#$%^&*()\s]+'(, '[\w\-_#@,.!@#$%^&*()\s]+')*$))))((\s*\b(AND|OR)\b\s*)(\s*\b([a-zA-Z_]*)\b)\s*((\s*=\s*(('[\w\-_#@,.!@#$%^&*()\s]*')))|((\s+\bLIKE\b\s+('[\w\-_#@,.!@#$%^&*()\s]*')))|(((\s+\bIN\b\s+$'[\w\-_#@,.!@#$%^&*()\s]+'(, '[\w\-_#@,.!@#$%^&*()\s]+')*$)))))*)

Open regex in editor

Description

Not fully compliant, please don't use for security or for anything extremely important. Might be a good jumping off point though (although its a bit hellish looking)

Submitted by anonymous - 2 months ago

Order By

Filter by Flavor

Community Patterns

nick anme

Get h1-6 tag

Match IPv4 Valid

^[A-Z,a-z,\-, ,\&]+$

01 Jan 2022 Mon 01:02:03

USD

Minimum 10 herhangi dijit

15.02.2022 15:00:00

Get ip address (only ipv6) Validator

Get ip address (only ipv4) Validator

Replace namespaces in xpath with local-name

for killerswim

Youtube Video Id

URL Validation

Camel-Case Splitter (preserves Acronyms)

SQL Condition

Regular ExpressionPCRE2 (PHP >=7.3)

Description

Regular Expression
PCRE2 (PHP >=7.3)