SELECT woes
От
Kevin Waterson
Тема
SELECT woes
Дата
Msg-id
20030902175133.199bdbc0.kevin@oceania.net
Список
Дерево обсуждения
SELECT woes Kevin Waterson <kevin@oceania.net>
Re: SELECT woes Jeffrey Melloy <jmelloy@visualdistortion.org>
Re: SELECT woes Kevin Waterson <kevin@oceania.net>
Re: SELECT woes Rasputin <rasputin@idoru.mine.nu>
Re: SELECT woes Jeffrey Melloy <jmelloy@visualdistortion.org>
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 по дате отправления
