Need search a value from database from comma separated string

Question

I have a table in database that is TEXT field. In this table i have stored my product ids . Now when i go to cart and get all product id of cart i want to match from database field and get only those ids that there stored in product id.

Please see image first.

In this field you will see "check_values" field. here all product ids are stored in comma separated.

Let me take a example

Like i have purchase a product that product id is 161. So i want to match 161 id from "check_value" filed and get only those ids (from images) that having 161.(11,14,15).

Hope you understand my question.

No, i want to match 161 from this table field (image) and get only those Ids that having 161. — Pritesh Mahajan, Oct 23 '15 at 19:18
Do not go forward with this design. Create another table with one id and one check_values per row. — AbraCadaver, Oct 23 '15 at 19:19
161 comes from other page. i just want to match from image table — Pritesh Mahajan, Oct 23 '15 at 19:19
Take a look at this thread for why you shouldn't store your data this way. http://stackoverflow.com/questions/3653462/is-storing-a-delimited-list-in-a-database-column-really-that-bad — chris85, Oct 23 '15 at 19:34
LIKE operator is just for you. It is not optimal and etc, but it will just work. — Ostin, Oct 23 '15 at 20:53
Possible duplicate of [MySQL query finding values in a comma separated string](http://stackoverflow.com/questions/5033047/mysql-query-finding-values-in-a-comma-separated-string) — Mark Amery, Oct 23 '15 at 23:35

score 3 · Answer 1 · answered Oct 23 '15 at 19:20

3

You can use FIND_IN_SET e.g.

SELECT * FROM images WHERE FIND_IN_SET(161, check_values) > 0

answered Oct 23 '15 at 19:20

rjdown

9,162
3
32
45

that was my next thought ;-) – Funk Forty Niner Oct 23 '15 at 19:21
I had totally forgotten about that function. – AbraCadaver Oct 23 '15 at 19:22

Need search a value from database from comma separated string

1 Answers1