Numeric
| Name | Description |
|---|---|
| %, MOD | Modulo operator |
| * | Multiplication operator |
| + | Addition operator |
| - | Minus operator |
| - | Change the sign of the argument |
| / | Division operator |
| ABS() | Return the absolute value |
| DIV | Integer division |
| EXP() | Raise to the power of |
| PI() | Return the value of pi |
| POW() / POWER() | Return the argument raised to the specified power |
| RAND() | Return a random floating-point value |
| SIGN() | Return the sign of the argument |
| SQRT() | Return the square root of the argument |
| ROUND() | Round the argument |
| CEIL() | Return the smallest integer value not less than the argument |
| FLOOR() | Return the largest integer value not greater than the argument |
String
| Name | Description |
|---|---|
| CHAR_LENGTH() / CHARACTER_LENGTH() | Return number of characters in argument |
| CONCAT() | Return concatenated string |
| CONCAT_WS() | Return concatenate with separator |
| LEFT() | Return the leftmost number of characters as specified |
| LOWER() | Return the argument in lowercase |
| REVERSE() | Reverse the characters in a string |
| RIGHT() | Return the specified rightmost number of characters |
| TRIM() | Remove leading and trailing spaces |
| UPPER() | Convert to uppercase |
| LIKE | Simple pattern matching |
| NOT LIKE | Negation of simple pattern matching |