[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

;o) 





More information about the thelist mailing list