How to search stored procedures containing a particular text?

select *
      from information_schema.routines
      where routine_definition like '%employee_id%'
      and routine_type='procedure'