[thelist] MySQL search everywhere?

[Matt Warden]

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

http://ss64.com/orad/USER_TAB_COLS.html

> 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
http://mattwarden.com


This email proudly and graciously contributes to entropy.