Re: [SQL] Searching Text Fields

See contrib/fulltextindex


> Hi all,
> 
> I need a way to search for a keyword that may appear as a substring in
> any field of any table.
> 
> There are 10 tables with 5 to 15 fields, most of them text and char
> fields, several thousand records.
> 
> How can I do it efficiently?
> 
> Can anyone point me to some useful information or show me an example?
> 
> 
> Thanks in advance
> 
> 
> Kind regards,
> 
> 
> Henrik Steffen
> city-map Stade
> http://www.Stade.net
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026