mysql-enum

[Anon]

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

[rsterbin]

You should use "set" instead of "enum". See:

http://www.mysql.com/doc/S/E/SET.html

Hope this helps,
Reha

mcshen wrote:

how do i store multiple data in one field?

[Anon]

ok. Now, i have this table
+-------+------+
| name | cat |
+-------+------+
| shen | a,c |
| shen1 | b,c |
+-------+------+

select * from test where cat='a'; returns nothing.

Wouldn't that display shen cuz shen contains a?

Also,

Select * from test where cat='c'; returns nothing too.

I was expecting it to output shen and shen1 cuz they both contain c

[mdmann]

I think you would need to use "like"
instead of "=":

select from test where cat like 'a';
select from test where cat like 'c';

The original queries were behaving just as
they should. You have no table entries where
cat is exactly equal to 'a' or 'c,' so
there should be no result from those
queries.

Michael

[mdmann]

You may have to put a "%" on one or both
sides of the value in the quotes:

select * from test where cat like 'a%';

or

select * from test where cat like '%a%';

and similarly for 'c'.

Michael