Where

Short and simple examples of how to use the where method to add a WHERE statement. While most of the examples show a SELECT query, the where method works exactly the same in UPDATE and DELETE queries too.

📄️ Simple where clause

where method calls are combined with AND:

📄️ Where in

Find multiple items using a list of identifiers:

📄️ OR where

To combine conditions using OR, you can use the expression builder:

📄️ Conditional where calls

You can add expressions conditionally like this:

📄️ Complex where clause

For complex where expressions you can pass in a single callback and