SELECT DISTINCT
SUBSTRING_INDEX( SUBSTRING_INDEX( a.`cgwcr`, ',', b.help_topic_id + 1 ), ',',- 1 ) sclass_id ,jxyjcgmc
FROM
1_7_ndjgjxglryjxyjcgqkylb a
JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.`cgwcr` ) - LENGTH( REPLACE ( a.`cgwcr`, ',', '' ) ) + 1 )
拆分逗号sql语句
最新推荐文章于 2024-03-24 19:49:34 发布