[thelist] MySQL search everywhere?

r937 rudy at r937.com
Thu Oct 15 09:53:28 CDT 2009

> String both of those items together in a loop or two within your favorite 
> scripting language ... and viola ... you can autogenerate all the SQL Rudy 
> outlined above.  Run that and you should be golden.

except for the obvious fact that you should never generate a LIKE predicate 
for anything other than character columns

as the saying goes, "the real WTF" is this whole idea of searching every 
column in every table


More information about the thelist mailing list