dozr13344 2017-11-13 06:37
浏览 60
已采纳

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

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 ?

  • 写回答

1条回答 默认 最新

  • dongye8110 2017-11-13 07:35
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?