Selecting values from comma seperated string in table using mysql

computerzworld

Hello,
I am having values stored in table in comma separated format like this.

1,2,4,5,7,9,11,15

I want to find whether particular value is available in this string or not using query.

Like I want to find whether 11 is available in the string or not and if it is available in that row it should display that row. How can I do this?

Please help me.

Thanks in advance.

Bjom

Have a look at the MySQL string functions

laserlight

computerzworld wrote:
I am having values stored in table in comma separated format like this.

1,2,4,5,7,9,11,15

That is probably the wrong approach to begin with. You should not be using multi-valued fields. Rather, you should create at least one more table to store those values, upon which the query you want would involve a join.

Bjom wrote:
Have a look at the MySQL string functions

This should only be used as a last resort, e.g., if you have no control over the database schema or if it is otherwise infeasible to have it changed.

djjjozsi

How can I do this

with this poor database design its hard to make. the internet is full of artices about "database normalization".

Bjom

@: very true

computerzworld

yes i know its a poor database design but it can still be done using mysql keyword

find_in_set()

Here is the explaination for it..

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set

HTH...
Thanks.