Regular Expressions 101

Order By

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

Community Patterns

1

SQL COLUMNS TO EMERGENCE COLUMNS SPEC v2

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

Sql Server Version Number

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

Alter SQL Create Table

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

Split SQL statements on 'GO'

PCRE (PHP <7.3)
Splits a SQL script into sections seperated by GO statement
Submitted by Michael Skovslund - 10 years ago
1

ConnectionStringServerDatabase

Python
Extract the server and database name from SQL Server connection string
Submitted by Davos - 10 years ago
1

match sql identifiers but not functions

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

Get table name from query

PCRE (PHP <7.3)
this extracts the table name in the from or join clause from SQL query
Submitted by vwei02 - 9 years ago
1

Extract name of tables from a SQL

PCRE (PHP <7.3)
Assumes the database name starts with "IDP_PRD_"
Submitted by Vance - 9 years ago
1

Sql where in list

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

right operand of parametirezed sql like expressions for sybase

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

Capture Comments on SQL followed by SELECT

Python
Shag Maister is the best
Submitted by anonymous - 9 years ago
1

SQL placeholder match

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

matching sql input

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

SQL Limit Clause

PCRE (PHP <7.3)
checks for valid limit clause of an sql statement
Submitted by Magesh Kumaar - 9 years ago
1

Extract Sql Columns from the given query

ECMAScript (JavaScript)
Tries to find the column names from the given SQL query.
Submitted by anonymous - 9 years ago
1

Get SQL FROM

PCRE (PHP <7.3)
SELECT * FROM wp_users WHERE user_login = 'username'
Submitted by Lars Jansen - 7 years ago
1

No permitir loop con sql

PCRE (PHP <7.3)
((LOOP\s+AT\s+\w\s+INTO\s+\w(.?)\s+)((INSERT|DELETE|UPDATE|MODIFY)\s+(\w\.?\?\s+)(FROM\s+\w\.\s*)?(ENDLOOP\.)))
Submitted by anonymous - 5 years ago
1

SQL comments Big Query

Golang
SQL comments on Big Query
Submitted by anonymous - 4 years ago
1

PHP PDO debugDumpParams parse as sql.

PCRE2 (PHP >=7.3)
解析php pdo 的 debugDumpParams 输出的数据。
Submitted by anonymous - 3 years ago
1

Imperva audit log regex

PCRE2 (PHP >=7.3)
Contains regex to parse the CockroachDB SQL audit log file
Submitted by Lesley Miller - 3 years ago
1234...6