关于mysql一个字段存储,多条规则数据需要分割的查询,或者查询插入的写法
SELECT a.id, IFNULL(SUBSTRING_INDEX(SUBSTRING_INDEX(a.[需要分割列名],[分割字符,比如:,],helpTopic.help_topic_id+1),[分割字符,比如:,],-1),'') FROM [TABLE_NAME] a
left join mysql.help_topic helpTopic
on helpTopic.help_topic_id < (LENGTH(a.[需要分割列名])-LENGTH(REPLACE([需要分割列名],[分割字符],''))+1);