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

Logical Query Functions

• IF() - Evaluate an expression and return one value if it evaluates to TRUE, otherwise a second value.
• IFNULL() - Evaluate an expression and return the result, unless it is NULL, then return an alternative value.
• ISNULL() - Evaluate an expression and return TRUE if it evaluates to NULL, otherwise FALSE.

• < YEAR()
• IF() >