Functions for use in SELECT and WHERE clauses

A select_expression or where_definition can consist of any expression using the following functions:

In the examples below the output of the mysql program has been shortened. So this:

mysql> select mod(29,9);
1 rows in set (0.00 sec)

+-----------+
| mod(29,9) |
+-----------+
|         2 |
+-----------+

Has been converted to:

mysql> select mod(29,9);                ->      2

• Grouping functions: Grouping functions.
• Arithmetic functions: Normal arithmetic operations.
• Bit functions: Bit functions.
• Logical functions: Logical operations.
• Comparison functions: Comparison operators.
• String comparison functions: String comparison functions.
• Control flow functions: Control flow functions.
• Mathematical functions: Mathematical functions.
• String functions: String functions.
• Date and time functions: Date and time functions
• Miscellaneous functions: Miscellaneous functions.
• Group by functions: Functions for GROUP BY clause.

Go to the first, previous, next, last section, table of contents.