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) then
select * 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)then
select * 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 )then
select * 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 ) then
select * from information_schema.events where locate('aa', event_definition) > 0 ; 
end if ;



END