Simple operators

All of the criteria that perform selections based on SQL field values have a certain number of operators available for their use.

{field operator value}

Here is a list of the simple operators:

  • = : equality operator {id_rubrique=8} selects records with "id_rubrique" equal to 8.
  • > : strictly greater than operator. {id_rubrique>8} selects records with "id_rubrique" greater than 8.
  • >= : greater or equal operator. {id_rubrique>=8} selects records with "id_rubrique" greater than or equal to 8.
  • < : strictly lesser than operator . {id_rubrique<8} selects records with "id_rubrique" less than 8.
  • <= : lesser or equal operator. {id_rubrique<=8} selects records with "id_rubrique" less than or equal to 8.
  • != : not equal operator {id_rubrique!=8} selects records with "id_rubrique" different from 8.

Author Mark Baber Published : Updated : 12/03/23

Translations : English, français