regex101: PCRE (Legacy) Match Workspace

1st Alternativefrom

fromthe literal text from (case insensitive)

2nd Alternativejoin

jointhe literal text join (case insensitive)

3rd Alternativetable

tablethe literal text table (case insensitive)

4th Alternativeinto

intothe literal text into (case insensitive)

5th Alternativeexists

existsthe literal text exists (case insensitive)

6th Alternativeupdate

updatethe literal text update (case insensitive)

the literal (32₁₀ / 40₈ / 20₁₆)

Negative Lookahead(?!IF)

IFthe literal text IF (case insensitive)

Group 1(\w+\.*)+

+repeats the group contents below at least once:

\w+any word character, repeated at least once

\.*the literal . (46₁₀ / 56₈ / 2E₁₆) , repeated any number of times

Global pattern flags

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

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

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

Search reference

Regular Expression

(?<=from|join|table|into|exists|update) (?!IF)(\w+\.*)+

New

SELECT * FROM COLLECTIONNAME.SCHEMANAME.TABLENAME LEFT JOIN SCHEMANAME.TABLENAME ON A.D = B.D

CREATE TABLE IF NOT EXISTS SCHEMANAME.NEWTABLENAME, SCHEMANAME.NEWTABLENAME

ALTER TABLE SCHEMANAME.EXISTINGTABLENAME

CREATE TABLE table_name (column_1 datatype, column_2 datatype, column_3 datatype);

DELETE FROM table_name WHERE some_column = some_value;

INSERT INTO table_name (column_1, column_2, column_3) VALUES (value_1, 'value_2', value_3);

select * from A join (select top 5 * from B) on B.ID = A.ID where A.ID in (select ID from C where C.DOB = A.DOB)

Select distinct W.WORKER_ID, W.FIRST_NAME, W.Salary 
from Table1 W, Table2 W1 
where W.Salary = W1.Salary 
and W.WORKER_ID != W1.WORKER_ID;

left

Regular Expressions 101

Regular Expression

Substitution