online website builder

Operators

 Filter values

Operators

Relations between variables

  • EQ - " = "
    must be the same
  • NOT_EQ - " <> "
    must be different
  • GT - " > "
    must be greater than
  • GTEQ - " >= "
    must be greater or equal to
  • LT - " < "
    must be less than
  • LTEQ - " <= "
    must be less or equal
  • IN - " in "
    must be one of the following
  • NOT_IN - " not in "
    can't be on of the following
  • IS_NULL - " is null "
    must be null
  • IS_NOT_NULL - " is not null "
    must not be null
  • LIKE - " like "
    must be like
  • NOT_LIKE - " not like "
    must be not like

EQ as default operator

Provide just column and value.

 

{...}.where(tabActor.colFirstName(),"James"){...}

You may provide Operator. If not, EQ will be in use.

Example:
Select.one(db,tabPizza).where(tabPizza.colPizzaId(),4).result();

© Copyright 2020 Elephant Software Klaudiusz Wojtkowiak 
e-mail: contact@daobab.io