Syntax:
SHOW {PROCEDURE | FUNCTION} STATUS
    [LIKE 'pattern' | WHERE expr]

These statements are MySQL extensions. They return characteristics of
routines, such as the database, name, type, creator, and creation and
modification dates. The LIKE clause, if present, indicates which
procedure or function names to match. The WHERE clause can be given to
select rows using more general conditions, as discussed in
http://dev.mysql.com/doc/refman/5.0/en/extended-show.html.

URL: http://dev.mysql.com/doc/refman/5.0/en/show-procedure-status.html

