Reference - Where syntax

 

Comma separated list of condition - each of these conditions must be satisfied to satisfy the where clause

Each condition has the following format:

Field Name or Joint, logical operator and value (string or numeric)

 

Available logical operators are: =, !=, <=, >= and ~= (contains)

 

 

Example :

quantity > 100, customer_id#customers.id:age = 21

 

 

» Reference