how to select and fetch from a comma saperated value mysql php

Question

i have a value

$id=10,12,4,45; //these are ids of all the products in product table

Now I want to show (echo) products' names which are given in this single variable.

something like:

query="SELECT description from product where id ='$id' ";

how to do that. thanks in advance...

Topic to read https://stackoverflow.com/questions/3653462/is-storing-a-delimited-list-in-a-database-column-really-that-bad — u_mulder, Mar 19 '19 at 10:21
@u_mulder I think (and I hope) this isn't stored in DB, this is the content of a php variable — Cid, Mar 19 '19 at 10:22
`$query="SELECT description from product where id in ('$id') ";` — splash58, Mar 19 '19 at 10:26

score 3 · Answer 1 · answered Mar 19 '19 at 10:20

3

Use find_in_Set()

SELECT description from product where find_in_set(id,'$id')

answered Mar 19 '19 at 10:20

Fahmi

1 Answers1