对账单月字段按逗号分隔形成多条数据

对“账单月”字段按逗号分隔形成多条数据SELECT a.id,substring_index(substring_index(a.bill_ids, #39;,#39;, b.id), #39;,#3

“” 对账单月字段按逗号分隔形成多条数据 SELECT a.id, substring_index(substring_index(a.bill_ids, #39;,#39;, b.id), #39;,#39;, -1) bill_ids, a.status, a.card_name FROM (SELECT id, bill_ids, status, card_name FROM af_repayment WHERE bill_idslt;#39; #39;) a JOIN af_activity_model bON b.id lt;= (length(a.bill_ids) - 1