regex101: Detect queries and whitespace before each of them

^start of line

Non-Capturing Group(?:[\n|\t])*

*repeats the group contents below any number of times:

Character Class[\n|\t]

\na line-feed (newline) character (ASCII 10)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

\ta tab character (ASCII 9)

.+?any character (except for line terminators), repeated at least once

Non-Capturing Group(?:[^;']|(?:'[^']+'))+

+repeats the group contents below at least once:

1st Alternative[^;']

Negated Character Class[^;']

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

'the literal ' (39₁₀ / 47₈ / 27₁₆)

2nd Alternative(?:'[^']+')

Non-Capturing Group(?:'[^']+')

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Negated Character Class[^']+

+matches at least one character outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

^(?:[\n|\t])*.+?(?:[^;']|(?:'[^']+'))+;$

New

SELECT * FROM database;
SELECT * FROM database WHERE somefield = 'somevalue';
SELECT * FROM database WHERE somefield = "somevalue";


EXPLAIN SELECT * FROM database WHERE somefield = "somevalue";
SELECT * FROM database WHERE somefield = 'somevalue' AND someotherfield = 'somemistypedstring;

SELECTing is hard, though, this is just text!;

SELECT
    *
FROM
    test_table
WHERE
    test_row = 'Testing ; semicolon';

SELECT * FROM another_test_table;

INSERT INTO 
    table_name 
VALUES 
    (value1,'value which contains semicolon ;;;;',value3,...);

WITH JOIN parcels
WHERE sp;


select * from accounts;

select * from events_stages_history;

Regular Expressions 101

Regular Expression

Extraction