values separated by ',' and query values

dimis2500 · #1 (**permalink**) 01-09-09, 08:37

I have a table

Quote:

mytable

that have a field

Quote:

myfield

with values separated by ',' .
I want to make a query that return values some spesific values (more than one) of

Quote:

myfield

(example 3,4 or 3 or 3,4,5).
Which is the best way to do that?
Dimis

healdem · #2 (**permalink**) 01-09-09, 08:44

Displaying column values in a row
?

mike_bike_kite · #3 (**permalink**) 01-09-09, 10:32

Most people try to get their data in to 3NF. Your data is not even in 1NF which is why you're having problems. I'd suggest reading up a bit on normal forms and then just altering your table to hold each value separately ie

Code:

# original string "aaa,bbb,,ddd,eee"

insert mytable ( seq, myfield ) values ( 1, "aaa" );
insert mytable ( seq, myfield ) values ( 2, "bbb" );
insert mytable ( seq, myfield ) values ( 4, "ddd" );
...

Then all you have to write is

Code:

select myfield from mytable where seq in (1,2,3)

Mike

Internet Services

Web Development

Digital Marketing

Consumer Tech