| Function | Description |
|---|---|
| BIN | Returns a binary representation of a number |
| BINARY | Converts a value to a binary string |
| CASE | Goes through conditions and return a value when the first condition is met |
| CAST | Converts a value (of any type) into a specified datatype |
| COALESCE | Returns the first non-null value in a list |
| CONNECTION_ID | Returns the unique connection ID for the current connection |
| CONV | Converts a number from one numeric base system to another |
| CONVERT | Converts a value into the specified datatype or character set |
| CURRENT_USER | Returns the user name and host name for the MySQL account that the server used to authenticate the current client |
| DATABASE | Returns the name of the current database |