The MySQL BIN() function returns a binary representation of a number, as a string value.

The MySQL BINARY function converts a value to a binary string.

The MySQL CASE statement goes through conditions and will stop reading and return a value when the first condition in the list is met.

The MySQL CAST() function converts a value of any type into the specified datatype.

The MySQL COALESCE() function returns the first non-null value in a list.

The MySQL CONNECTION_ID() function returns the unique connection ID for the current connection.

The MySQL CONV() function converts a number from one numeric base system to another, and returns the result as a string value.

The MySQL CONVERT() function converts a value into the specified datatype or character set.

The MySQL CURRENT_USER() function returns the user name and host name for the MySQL account that the server used to authenticate the current client.

The MySQL DATABASE() function returns the name of the current database. If there is no current database, this function returns NULL or “”.

The MySQL ISNULL() function returns 1 (null) or 0 (not null) depending on whether an expression is NULL.

The MySQL LAST_INSERT_ID() function returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table.

The MySQL NULLIF() function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned.

The MySQL SESSION_USER() function returns the current user name and host name for the MySQL connection.

The MySQL SYSTEM_USER() function returns the current user name and host name for the MySQL connection.

The MySQL USER() function returns the current user name and host name for the MySQL connection.

The MySQL VERSION() function returns the current version of the MySQL database, as a string.