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 ?
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.