Regular Expressions 101

Order By

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

Community Patterns

0

SQL Index to migration call

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 5 years ago
0

otra de sql con variables

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 5 years ago
0

Choose column names from SQL string

ECMAScript (JavaScript)
no description available
Submitted by anonymous - 5 years ago
0

SQLA example

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 5 years ago
0

SQL Query

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 5 years ago (Last modified 2 years ago)
0

Regex Replace params SQL

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 5 years ago
0

Add space after comma if it has letters on each side.

PCRE (PHP <7.3)
This is used in the SQL_Pretty_Formatter after the commas inside quotes, parenthesis, and brackets have been temporarily replaced with |.
Submitted by Ben - 5 years ago
0

Find all commas that are not in parenthesis. Used in SQL_Pretty_Format()

ECMAScript (JavaScript)
Find all commas that are not in parenthesis or square brackets.
Submitted by Ben - 5 years ago
0

Convert list for use in SQL IN statement

PCRE2 (PHP >=7.3)
Just need to remove the last ,
Submitted by Ian1971 - 4 years ago
0

Json Starts With Keys

PCRE2 (PHP >=7.3)
Regex for checking if JSON starts with desired keys Useful for validating/filtering database entries when used in combination with SQL Like Example: Postgre: select * from table_name where column_json ~ '^\{[\s]\"(tab1|tab3|tab5)".'
Submitted by MUA - 4 years ago
0

Select LIMIT-OFFSET clause in SQL query

ECMAScript (JavaScript)
Select the LIMIT/OFFSET clause of an SQL query
Submitted by Matthew Marcus - 4 years ago
0

flake8-sql False Positives

Python
An example false positive matching docstring for the regex used by flake8-sql (https://github.com/pgjones/flake8-sql).
Submitted by anonymous - 3 years ago (Last modified 3 years ago)
0

SQL Processes Filter

PCRE2 (PHP >=7.3)
Pattern to detect certain SQL queries in the PROCESSLIST results.
Submitted by anonymous - 3 years ago
0

SQL Query Scalar Field Names Extractor

Java 8
SQL Query Scalar Field Names Extractor
Submitted by Dobri - 3 years ago
0

Find more than one word in SQL

PCRE2 (PHP >=7.3)
Finds instances of more than one word in SQL.
Submitted by Matthew Hiebing - 3 years ago
0

sql inj

ECMAScript (JavaScript)
as
Submitted by anonymous - 3 years ago
0

Extract CREATE TABLE statements from SQL dump file

PCRE2 (PHP >=7.3)
Usage: pcre2grep -M -e'^(CREATE TABLE*?;)' dump.sql > create-tables.sql
Submitted by Daniel J. Post - 3 years ago
0

Find SQL injection opportunities

PCRE2 (PHP >=7.3)
-
Submitted by anonymous - 3 years ago
0

non-sargable finder

PCRE2 (PHP >=7.3)
find non-sargable sql
Submitted by nick preston - 2 years ago
-2

Parsing result of SQL Server version (SELECT @@VERSION)

.NET 7.0 (C#)
Parses MS SQL Server version returned from executing SELECT @@version
Submitted by M Rivas - 3 years ago
123456