search

greenlion / PHP-SQL-Parser

A pure PHP SQL (non validating) parser w/ focus on MySQL dialect of SQL
BSD 3-Clause "New" or "Revised" License
607 stars 156 forks source link

Enable subquery support in WHERE expression #317

Closed LudoMon closed 4 years ago

LudoMon commented 4 years ago

The use of a subquery in a WHERE bracket expression was not correctly handled by the parser:

SELECT myField FROM myTable WHERE filterField IN ( SELECT otherField FROM otherTable )

Closes #316