--將text替換成你要查詢的內容 SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE `%AgentRoomCardOrder%` AND ROUTINE_TYPE=`PROCEDURE`
--將text替換成你要查詢的內容 SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE `%AgentRoomCardOrder%` AND ROUTINE_TYPE=`PROCEDURE`