特别是从mysql数据库中获取逗号分隔值

Question

I have database where i have a column where multiple ids are saved in comma separated way. That ids are defined some other table . I am fetching the but i am getting result where there is single value (no comma)

i need all all the ids value fetched there definition from another table and show.

Is it possible in mysql query ?

Answer 1

Get first all id's,by column, and then explode it by comma,

$explode = explode(',',$array->column);

then using foreach pass the value to another table to get the row,

 foreach($explode as $single){
  // pass single id to query using where condition you can get row of that id.
 }

or you can also use subquery, do google am sure stack overflow gives better result.