Community Patterns

Community Library Entry

1

Regular Expression
Created·2016-05-27 22:16
Flavor·PCRE (Legacy)

/
(?<=FROM|JOIN|OJ)[\s\(]+(((`?[\w_]+`?)(\s*,\s*)*)+)
/
gi
Open regex in editor

Description

Finds table names in table list and subqueries. Table names are in group #1 of all matches One note. In case of table list (like SELECT * FROM table1, table2, etc) group#1 will contain all tables string (like "table1, table2, etc") so it's necessary to do additional handing like splitting the string

Submitted by Mykhaylo Khodorev (mykhaylo.khodorev@gmail.com)