POSITION(substr IN str) SUBSTR(str FROM pos) SUBSTR(str FROM pos FOR len) TRIM({BOTH | LEADING | TRAILING} remstr FROM str) TRIM(remstr FROM str) expr [NOT] REGEXP pat expr [NOT] RLIKE pat a DIV b a MOD b ADDDATE(date, INTERVAL expr_unit) DATE_ADD(date, INTERVAL expr_unit) DATE_SUB(date, INTERVAL expr_unit EXTRACT(unit FROM date) SUBDATE(...) BINARY expr CAST(expr AS type) -> type names