Skip to main content

SHOW FUNCTIONS

Shows the list of supported functions currently, including builtin scalar/aggregate functions and user defined functions.

Syntax​

SHOW FUNCTIONS  [LIKE 'pattern' | WHERE expr]

Example​

mysql> SHOW FUNCTIONS;
+-------------------------+------------+--------------+-------------------+---------------------------+
| name                    | is_builtin | is_aggregate | definition        | description               |
+-------------------------+------------+--------------+-------------------+---------------------------+
| !=                      |          1 |            0 |                   |                           |
| %                       |          1 |            0 |                   |                           |
| *                       |          1 |            0 |                   |                           |
| +                       |          1 |            0 |                   |                           |
| -                       |          1 |            0 |                   |                           |
| /                       |          1 |            0 |                   |                           |
| <                       |          1 |            0 |                   |                           |
| <=                      |          1 |            0 |                   |                           |
| <>                      |          1 |            0 |                   |                           |
| =                       |          1 |            0 |                   |                           |
+-------------------------+------------+--------------+-------------------+---------------------------+

Showing the functions begin with "today":

mysql> SHOW FUNCTIONS LIKE 'today%';
+--------------+------------+--------------+------------+-------------+
| name         | is_builtin | is_aggregate | definition | description |
+--------------+------------+--------------+------------+-------------+
| today        |          1 |            0 |            |             |
| todayofmonth |          1 |            0 |            |             |
| todayofweek  |          1 |            0 |            |             |
| todayofyear  |          1 |            0 |            |             |
+--------------+------------+--------------+------------+-------------+

Showing the functions begin with "today" with WHERE:

mysql> SHOW FUNCTIONS WHERE name LIKE 'today%';
+--------------+------------+--------------+------------+-------------+
| name         | is_builtin | is_aggregate | definition | description |
+--------------+------------+--------------+------------+-------------+
| today        |          1 |            0 |            |             |
| todayofmonth |          1 |            0 |            |             |
| todayofweek  |          1 |            0 |            |             |
| todayofyear  |          1 |            0 |            |             |
+--------------+------------+--------------+------------+-------------+