diff options
author | Simon Holywell <[email protected]> | 2014-05-28 15:22:59 +0100 |
---|---|---|
committer | Simon Holywell <[email protected]> | 2014-05-28 15:22:59 +0100 |
commit | de4a611d5c3676e3b505c4a6812ccc91ec049d61 (patch) | |
tree | 9c4523af5600d021cb3c1c6b786fb54ebbd471f5 /docs/querying.rst | |
parent | a1b30b9a8889110e5e6bbad06efe36ed0454468a (diff) | |
parent | 3f86f09173e4acf0443018121207cffb0e4fe6c7 (diff) |
Merge pull request #201 from lrlopez/where_any_is
Multiple OR'ed conditions support
Diffstat (limited to 'docs/querying.rst')
-rw-r--r-- | docs/querying.rst | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/docs/querying.rst b/docs/querying.rst index 8541fa8..f86f162 100644 --- a/docs/querying.rst +++ b/docs/querying.rst @@ -306,6 +306,54 @@ Similarly, to add a ``WHERE ... NOT LIKE`` clause, use: <?php $people = ORM::for_table('person')->where_not_like('name', '%bob%')->find_many(); +Multiple OR'ed conditions +''''''''''''''''''''''''' + +You can add simple OR'ed conditions to the same WHERE clause using ``where_any_is``. You +should specify multiple conditions using an array of items. Each item will be an +associative array that contains a multiple conditions. + +.. code-block:: php + + <?php + $people = ORM::for_table('person') + ->where_any_is(array( + array('name' => 'Joe', 'age' => 10), + array('name' => 'Fred', 'age' => 20))) + ->find_many(); + + // Creates SQL: + SELECT * FROM `widget` WHERE (( `name` = 'Joe' AND `age` = '10' ) OR ( `name` = 'Fred' AND `age` = '20' )); + +By default, it uses the equal operator for every column, but it can be overriden for any +column using a second parameter: + +.. code-block:: php + + <?php + $people = ORM::for_table('person') + ->where_any_is(array( + array('name' => 'Joe', 'age' => 10), + array('name' => 'Fred', 'age' => 20)), array('age' => '>')) + ->find_many(); + + // Creates SQL: + SELECT * FROM `widget` WHERE (( `name` = 'Joe' AND `age` > '10' ) OR ( `name` = 'Fred' AND `age` > '20' )); + +If you want to set the default operator for all the columns, just pass it as the second parameter: + +.. code-block:: php + + <?php + $people = ORM::for_table('person') + ->where_any_is(array( + array('score' => '5', 'age' => 10), + array('score' => '15', 'age' => 20)), '>') + ->find_many(); + + // Creates SQL: + SELECT * FROM `widget` WHERE (( `score` > '5' AND `age` > '10' ) OR ( `score` > '15' AND `age` > '20' )); + Set membership: ``where_in`` and ``where_not_in`` ''''''''''''''''''''''''''''''''''''''''''''''''' |