Here you can find categories of functions and operators those are available in MySQL alongwith examples that show how to use several of them.

Functions can be invoked within expressions and return a value that is used in place of the function call when the expression is evaluated. When you invoke a function, there must be no space after the function name and before the opening parenthesis. It's possible to change this default behavior by enabling the IGNORE_SPACE SQL mode to cause spaces after the function name to be ignored. Take examples below:

mysql> SELECT PI ();
ERROR 1305 (42000): FUNCTION world.PI does not exist

mysql> SET sql_mode = 'IGNORE_SPACE';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT PI ();
+----------+
| PI ()    |
+----------+
| 3.141593 |
+----------+
1 row in set (0.00 sec)

Funtions and Operators Related FAQs

What is MySQL date format and its specifiers?

How to get comma separated all values in a single row against each ID?

How to concat values in MySQL?

How to convert time zone in MySQL?

What are comparison functions in MySQL

How to set conditions on query data with CASE construct?

How to set control conditions on query data with IF funtion?

What are mathematical functions in MySQL?

How are aggregate functions in MySQL?

What are string functions in MySQL?

What are temporal or date time functions in MySQL?

What are NULL value related functions in MySQL?

How does union work in MySQL?