Re: sql query question
| From: | Steve Solomon | Date: | Thu, 12 Feb 2004 23:00:10 +0000 |
| Subject: | Re: sql query question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-177551@lists.php.net to get a copy of this message | ||
select * from table where locate("new",descript)>0 or
locate("car",descript)>0;
"Tony" <awardd@essex.ac.uk> wrote in message
news:20040212210024.61938.qmail@pb1.pair.com...
hi
if i have new car and i want to search
each word in description
can i do
SELECT * FROM table WHERE
descript = "new" OR descript ="car"??
any help is appreciated