Sometimes you need to search for a stored procedures without knowing its exact name, or to find all of the procedures that begin with a certain naming prefix. Tables that follow a particular naming convention can be found by searching against the name in the same way.
-- Search table names
WHERE TABLE_NAME LIKE 'tmp_%';
-- Search stored procedure names
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND ROUTINE_NAME LIKE 'tmp_%';