Dynamic Find using LIKE

keep in mind querying with LIKE is a great performance hit. what you really need is full text search, using either built in Mysql engine (works on MyISAM tables only, so forget about foreign keys etc) or postgresql tsearch2 or ferret (lucene ruby port) or whatever solution you find appropriate for your dbms. LIKE is not an option, tho.