Re: This is really a MySQL question...
| From: | Mark Maggelet | Date: | Fri, 08 Sep 2000 22:44:33 +0000 |
| Subject: | Re: This is really a MySQL question... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-15961@lists.php.net to get a copy of this message | ||
On Fri, 8 Sep 2000 18:13:18 -0500 (CDT), Colleen R Dick
(platypus@zwallet.com) wrote:
>very simple question, how do you select a subset of a set
>
>lets say you have a set colum with possibility of a,b,c, and/ or d
>
>let's say you want to pull in all records where that set column
>contains a or b
select * from table where find_in_set('a',column)>0 or
find_in_set('b',column)>0;
>let's say you want to pull in all records where it has both a and c
>
>I can't find this in any of my books but there must be a way to do
>it.
read the online documentation at www.mysql.com