WHERE clause
where-clause:
WHERE condition
condition:
expression
The WHERE clause serves to filter a stream of variable bindings, retaining those bindings for which the truth value of the WHERE clause is TRUE and discarding the bindings for which this truth value is FALSE.
Example
SELECT * FROM tutorial WHERE fname = 'Ian'
Returns:
{ "results": [ { "age": 56, "children": [ { "age": 17, "fname": "Abama", "gender": "m" }, { "age": 21, "fname": "Bebama", "gender": "m" } ], "email": "ian@gmail.com", "fname": "Ian", "hobbies": [ "golf", "surfing" ], "lname": "Taylor", "relation": "cousin", "title": "Mr.", "type": "contact" } ] }