Re: Re: enum !!

ok. I use set to make a table. here is my table 'test' +-------+------+ | name | cat | +-------+------+ | shen | a,c | | shen1 | b,c | +-------+------+ How can I find all records that contain 'c'? i tried select * from test where cat='c'; it returned "empty set"; please help "Tom Hodder" <t.hodder@globalgold.co.uk> wrote in message news:NOEMKHKHBPNACMAIJAPECEPMCCAA.t.hodder@globalgold.co.uk... > > First normal form (1NF), A table in which the intersection of every column > and record contains one, and only one, value. > > > > -----Original Message----- > From: Hugh Bothwell [mailto:hugh_bothwell@hotmail.com] > Sent: 16 July 2001 19:21 > To: php-db@lists.php.net > Subject: [PHP-DB] Re: enum !! > > > > "McShen" <hshen@crosswinds.net> wrote in message > news:20010716174257.47906.qmail@pb1.pair.com... > > how do i store multiple data in one field? > > i have a table like this > > > > +-------+-------------------+------+-----+---------+-------+ > > | Field | Type | Null | Key | Default | Extra | > > +-------+-------------------+------+-----+---------+-------+ > > | test | enum('a','b','c') | YES | | NULL | | > > +-------+-------------------+------+-----+---------+-------+ > > > > insert into test values('a','b','c'); doens't work. > > please help > > Your query is mixed up; 'test' is the field name, not the table name, and I > think you want to put the values into three separate records, not one... > > Try > INSERT INTO tablename ( test ) VALUES ( 'a' ), ( 'b'), ('c'), > (''); > > This should get you four records, with 'test' values of a, b, c, and null. > > If you want to store more than one value in the same record, you should be > looking at sets, not enums. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >