SELECT DISTINCT
substring_index(substring_index(a.value, ‘\n‘, b.help_topic_id + 1), ‘\n‘,- 1) NAME
FROM t_cr_permission a
JOIN mysql.help_topic b ON b.help_topic_id < (length(a.value) - length(REPLACE(a.value, ‘\n‘, ‘‘)) + 1)
WHERE a.id =1
原文：https://www.cnblogs.com/tonggc1668/p/14802826.html