search text inside all procedures

User, date Message
Written by BubikolRamios
9 months ago
Category: General
273 posts since Thu, 14 Jan 10 		Is that possible to do in HSQL, if not that would be feature request.
Written by microUgly
9 months ago
20 posts since Fri, 16 Apr 10 		I don't think HeidiSQL can do this, but it's easy enough to do it with a regular query:

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='yourDB' AND ROUTINE_BODY LIKE '%search%';
 

Please login to leave a reply, or register at first.