SELECT
a.id,
substring_index(
substring_index(
a.cover_area_name,
',',
help_topic_id + 1
),
',' ,- 1
) AS shareholder
FROM message_send a left join message c on a.message_id = c.id
JOIN mysql.help_topic b ON b.help_topic_id < (
length(a.cover_area_name) - length(
REPLACE (a.cover_area_name, ',', '')
) + 1
);
此函数需要有mysql库的权限