MariaDB search for text in database routines MySQL SELECT ROUTINE_NAME FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_DEFINITION` LIKE '%mysearchhere%'; 12 SELECT ROUTINE_NAME FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_DEFINITION` LIKE '%mysearchhere%';