SELECT    
      ROUTINE_NAME,
      ROUTINE_DEFINITION
FROM    
      INFORMATION_SCHEMA.ROUTINES
WHERE    
      ROUTINE_DEFINITION LIKE '%whatever you are looking for%'
ORDER BY
      ROUTINE_NAME