mysql findcode

CREATE DEFINER = 'lijiwei'@'192.168.16.33'PROCEDURE ayst_share.findcode(IN v_object_name VARCHAR(255))BEGIN/*  FUNCTION:   该程序的设计目标是，当技术人员输入一个代码片段时，可以智能化查找并显示出用户所输入的代码所在对象的相关信息  以便技术人员快速地跟踪调试程序，方便解决相关问题。   created date: 2016/9/29   */if (select 1 from information_schema.routines where locate(v_object_name, routine_definition) > 0 limit 1) thenselect * from information_schema.routines where locate(v_object_name, routine_definition) > 0 ; end if ;if (select 1 from information_schema.views where locate('aa', view_definition) > 0 limit 1)thenselect * from information_schema.views where locate('aa', view_definition) > 0 ;   end if ;if (select 1 from information_schema.triggers where locate('aa', action_statement) > 0 limit 1 )thenselect * from information_schema.triggers where locate('aa', action_statement) > 0 ;   end if ;if (select 1 from information_schema.events where locate('aa', event_definition) > 0 limit 1 ) thenselect * from information_schema.events where locate('aa', event_definition) > 0 ; end if ;END