1 .把字段中的逗号(,)替换成 分号(;)
select id,markId,REPLACE(jdorders,',',';') as jdorders from ip_c_bill ORDER BY id desc