Re: Re: enum !!

BTW, did i insert those data correctly? here was what i type insert into test values('shen','a,c'); insert into test values('shen1','a,c'); I think they were wrong. How do i insert 2 values ? "McShen" <hshen@crosswinds.net> wrote in message news:20010716184844.89676.qmail@pb1.pair.com... > 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 > > > > > >