[thelist] MySQL search everywhere?

Matt Warden mwarden at gmail.com
Thu Oct 15 10:30:34 CDT 2009

On Thu, Oct 15, 2009 at 10:53 AM, r937 <rudy at r937.com> wrote:
>> 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

That can be easily filtered out using a join with USER_TAB_COLS


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

Agree. I'd be interested to see the table definition :)

Matt Warden
Cincinnati, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list