• ⌂ Logical
• Functions
  • IF()
  • IFNULL()
  • ISNULL()

Logical Query Functions

• IF(Condition,True,False) - If Condition is TRUE, True is returned, otherwise False, where True and False are expressions.
• IFNULL(Field,Value) - If Field is NULL, Value is returned, otherwise Field is returned.
• ISNULL(Field) - Returns TRUE if Field is NULL, otherwise FALSE.

• < YEAR()
• IF() >