RE: [PHP-DB] LIKE statement or IN statement?
| From: | Chris Barnes | Date: | Mon, 04 Nov 2002 00:00:41 +0000 |
| Subject: | RE: [PHP-DB] LIKE statement or IN statement? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22939@lists.php.net to get a copy of this message | ||
Yeah I really need to search for multiple words. Can anyone confirm if
the IN statement will work for me in this situation?
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
>
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc