Chris Barnes wrote:
Chris --Hi, I've got a dilly of a problem. I'm probably doing something wrong but I don't know what. I'm trying to use the LIKE statement in a query where more than one word is used in with LIKE..e.g.select count(distinct itemid) from business where name or description like 'word1 word2 word3%'
The answer depends on what database you using? MySQL has a IN operator, so you might try:
SELECT * from table
WHERE name IN ('value1','value2','value3)
WHERE description IN ('value1','value2','value3)
Your might want to cross post to MySQL list.
The problem I'm having is probably obvious to you but I don't know why this returns no matches but if i specify only 1 word in the LIKE statement then it returns a match. Am i not able to specify more than 1 word with LIKE or am I just doing it wrong? It has been designed to take input from a web form by the variable $search_string and then the query string is constructed from that e.g. $query = "select count(distinct itemid) from business where name or description like'" . $search_string . "'"; Any help or suggestions greatly appreciated.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php