auraphp/Aura.SqlQuery

Where with parentheses

Opened this issue · 0 comments

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.