📄️ Filter by id
To find a record by id use the .where method with the = operator as follows.
📄️ Filter by simple condition
In this example we're using .where to find all persons aged between 18 and 60.
📄️ Filter by optional conditions
You can easily add optional where calls as shown below.
📄️ Filter by OR condition
In this example we build a more complex WHERE statement that uses both AND and OR.
📄️ Filter by list
In this example we find multiple records using a WHERE IN filter.
📄️ Filter by subquery
This example finds all persons who have a dog as a pet using a subquery.
📄️ Function calls in a WHERE statement
If you need to call a function in a WHERE statement (or anywhere, really) you can use the