==作者：YB-Chi==

SELECT substring_index(substring_index(a.event_samples, '&TAB&', b.help_topic_id + 1), '&TAB&', - 1) AS event_sample
FROM parser_rule a
INNER JOIN 
mysql.help_topic b
ON b.help_topic_id < ((length(a.event_samples) - length(REPLACE(a.event_samples, '&TAB&', '')))/5 + 1)
group by event_sample

PS: /5是因为分隔符为5位