mysql怎么把固定的几个字符串,转成列的形式作为临时表查询答:1),',' ,- 1)) AS numbfrom (select '39982665399,39023431098,39764974481,39055572973,39897342743,40127675336,40174795679' as num from dual ) a JOIN apsc.help_topic b ON b.help_topic_id <(length(a.num) - length( REPLACE(a.num, ',', '') ) + 1 )希望能帮到你!