A newer version of this documentation is available.

View Latest

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