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
