Functions & expressions

Example

SELECT
  UPPER(name),
  LENGTH(body),
  COALESCE(nickname, name, 'anonymous'),
  CONCAT(first, ' ', last),
  SUBSTRING(body, 1, 100),
  TRIM(LOWER(email)),
  ROUND(price * 1.2, 2),
  CASE
    WHEN age < 18 THEN 'minor'
    WHEN age < 65 THEN 'adult'
    ELSE 'senior'
  END,
  NOW()
FROM users;

Functions

UPPER, LOWER, LENGTH, COALESCE, IFNULL, NULLIF, CONCAT, CONCAT_WS, SUBSTRING, TRIM, LTRIM, RTRIM, REPLACE, ABS, ROUND, FLOOR, CEIL, MOD, POWER, SQRT, NOW, CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME.

Operators

+, -, *, /, %, || (concatenation), =, !=/<>, <, >, <=, >=, AND, OR, NOT, IS [NOT] NULL.