How to create grouped WHERE

[Mário Pálka]

Hello,

how would you transform this SQL query into NotORM?

SELECT * FROM items WHERE (column1 > 0 AND column2 > 0) OR (column3 < 0 AND column4 < 0);

It's just dummy example, where I want to ask for AND and OR grouped by brackets.

Thank you

[Allysson David]

AFAIK, each call to WHERE, AND and OR will result in a "cell condition", so you could do it like this:

$db->items()->where("column1 > ? AND column 2 > ?", array(0, 0))->or("column3 < ? AND column4 < ?", array(0, 0));

Or even like this:

$db->items()->where("(column1 > ? AND column 2 > ?) OR (column3 < ? AND column4 < ?)", 0, 0, 0, 0);

Note: Parameters could be either arrays or not. 

--
You received this message because you are subscribed to the Google Groups "NotORM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to notorm+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mário Pálka]

Thank you for your advice!

To unsubscribe from this group and stop receiving emails from it, send an email to notorm+un...@googlegroups.com.