SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(group_id, ',', b.help_topic_id + 1), ',',- 1)
FROM
`group_sms_send_rule` a
JOIN mysql.`help_topic` b
ON b.help_topic_id < (
LENGTH(a.`group_id`) - LENGTH(REPLACE(a.`group_id`, ',', '')) + 1 )
WHERE id = 1716 ;
mysql列转行
最新推荐文章于 2024-02-01 17:18:00 发布