Regular Expressions 101

All the errors detected are listed below, from left to right, as they appear in the pattern.

\G Escape is not recognized by the selected flavor

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?:SELECT\s++(?=(?:[#\w,`.]++\s++)+)|(?!^)\G\s*+,\s*+(?:`?+\s*+[#\w]++\s*+`?+\s*+\.\s*+)?+`?+\s*+)(\w++)`?+(?:\s++as\s++[^,\s]++)?+

New

SELECT columnA, columnB as foo, table.column8, table.column3 as foo, 
       `column7`, `column4` as foo, `table`.`columnZ`, `#__table`.`columnF` as foo FROM datable where

Select column1, column2 From table

select column0 from table

Extraction