SELECT woes

Поиск
Список
Период
Сортировка
От Kevin Waterson
Тема SELECT woes
Дата
Msg-id 20030902175133.199bdbc0.kevin@oceania.net
обсуждение исходный текст
Ответы Re: SELECT woes
Список pgsql-novice
I wish to SELECT * FROM testTable WHERE any field contains any word in the
string "my name is bill"
All I can come up with is this.
SELECT * FROM testTable WHERE testfeild LIKE '%my%' OR testfield2 LIKE '%my%' OR testfeild LIKE '%name%' OR testfield2
LIKE'%name%' OR testfeild LIKE '%is%' OR testfield2 LIKE '%is%' OR testfeild LIKE '%bill%' OR testfield2 LIKE '%bill%' 

Is there a better/more efficient way?

Kind regards
Kevin

--
 ______
(_____ \
 _____) )  ____   ____   ____   ____
|  ____/  / _  ) / _  | / ___) / _  )
| |      ( (/ / ( ( | |( (___ ( (/ /
|_|       \____) \_||_| \____) \____)
Kevin Waterson
Port Macquarie, Australia

В списке pgsql-novice по дате отправления: