Re: Search for a word in all columns in all rows

Uzytkownik "Dil Jaey" <diljaey_at_comcast.net>
> I am allowing users to enter in a keyword search via a web interface
> and in the backend Oracle 9i is requested to search for that keyword
> in all columns (30) for every row (thousands) that exists within a
> given table(s).
>
> Is this a relatively simple task to perform or is this a path that
> should not be traveled.

SELECT 1
   FROM 30_column_table
 WHERE col1||col2||.....||col30 like '%find_this_stuff%'

... if length of that concatenate doesn't exeed 2000 or 4000 bytes... it could be done with one FTS, and long a few seconds with tousands of rows.

--
Noel