SELECT * FROM mysql.proc
WHERE type = 'PROCEDURE'
AND Body LIKE '%字符串%';
-
mysql.proc:表示查询的目标表;
-
type = 'PROCEDURE':表示查询的是存储过程;
-
Body LIKE '%字符串%':表示存储过程内容中包含的字符串。
SELECT * FROM mysql.proc WHERE type = 'PROCEDURE' AND Body LIKE '%Report_UserBetDayDetail%';