RE: [PHP-DB] LIKE statement or IN statement?
| From: | Amit_Wadhwa at Dell dot com | Date: | Mon, 04 Nov 2002 01:19:52 +0000 |
| Subject: | RE: [PHP-DB] LIKE statement or IN statement? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22943@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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