ok so you would have to use : --select count(distinct itemid) from business where name like 'word1' or name like 'word2' or name like 'word3'; no other go. ........................................................................ .. You can't use wildcards with IN, only with LIKE or regular expressions. ---John Holmes... > -----Original Message----- > From: Amit_Wadhwa@Dell.com [mailto:Amit_Wadhwa@Dell.com] > Sent: Sunday, November 03, 2002 5:31 PM > To: php-db@lists.php.net > Subject: RE: LIKE statement or IN statement? > > 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
