WHERE clause

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"
     }
   ]
 }