Mysql semicolon separates the field. Split
Question-- how does mysql split a string that is split by
Split the fields of commas and semicolons. Other fields are automatically completed.
Https://blog.csdn.net/u012009613/article/details/52770567 SELECT s.* from (SELECT t.IDMagnet.timekeeper, substring_index (substring_index (t.all_content,';', b.help_topic_id + 1),';',-1) content_split-- t..FROM excel_lvli t JOIN mysql.help_topic b ON b.help_topic_id
< ( LENGTH( t.all_content ) - LENGTH( REPLACE ( t.all_content, '；', '' ) ) + 1 )and t.all_content like '%；%'and t.all_content like '%画了许多%' ) s WHERE LENGTH(s.content_split) >0; SELECT substring_index (substring_index (t.context,',', b.help_topic_id + 1),',',-1) FROM test.test t JOIN mysql.help_topic b ON b.help_topic_id < (LENGTH (t.context)-LENGTH (REPLACE (t.context,',')) + 1)
The effect achieved. :
