RE: [PHP-DB] LIKE statement or IN statement?
| From: | John W. Holmes | Date: | Mon, 04 Nov 2002 01:24:16 +0000 |
| Subject: | RE: [PHP-DB] LIKE statement or IN statement? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22945@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.
If you're not going to use wildcards, then you can use IN. The whole
idea of using LIKE is that you can use _ and % as wildcards when
searching.
---John Holmes...