search

auraphp / Aura.SqlQuery

Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
MIT License
452 stars 86 forks source link

Where with parentheses #183

Open designermonkey opened 3 years ago

designermonkey commented 3 years ago

Maybe I'm missing something... How would I replicate the following?

where (
    find_in_set(tests.`compound.group`, :compound_groups) or
    find_in_set(tests.`compound.name`, :compound_names)
)
and (
    find_in_set(isolates.`species.genus`, :species_genera) or
    find_in_set(isolates.`species.name`, :species_names)
)

The parentheses are important in the above, and I can't figure out how I should do it with SQLQuery.