Re: LIKE statement or IN statement?

Chris Barnes wrote:

Yeah I really need to search for multiple words. Can anyone confirm if the IN statement will work for me in this situation? Chris --

Why not just try it you self and let's us know. Also check to MySQL doc at http://mysql.org David

On Mon, 2002-11-04 at 09:31, Amit_Wadhwa@Dell.com wrote:

if you want to search for multiple words, u have to use multiple like operators: select count(distinct itemid) from business where name like 'word1' or name like 'word2' or name like 'word3'; or the IN statement with wildcards: select count(distinct itemid) from business where name IN ('%word1%','%word2%','%word3%'); <-- im not too sure of this, would the experts please shed some more light on this one if its correct? Amit On 4 Nov 2002, Chris Barnes wrote:

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 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.

------------------------------------------------------------------------ ---

Peter Beckman            Systems Engineer, Fairfax Cable Access

Corporation beckman@purplecow.com http://www.purplecow.com/ ------------------------------------------------------------------------ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php