Find any text into Stored Procedure and Function of MySQL

In this post, I am sharing a script to find any text in Stored Procedure and Function of MySQL.

Many times we need to find any object name, column name or comment text in MySQL Routines.

Below is a script to achieve this:

1 2 3 4 5 6 7

SELECT      Routine_Schema     ,Routine_Name     ,Routine_Type FROM information_schema.routines WHERE routines.routine_definition LIKE '%Any_Text%' AND Routine_Schema = 'db_Name'