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 >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
