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 по дате отправления: