select * from table where locate("new",descript)>0 or locate("car",descript)>0;
"Tony" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php