SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX(keep_watch_route.staff_user_id,',',help_topic_id+1),',',-1) AS num
FROM
keep_watch_route,
mysql.help_topic
WHERE keep_watch_route.`status`='0' and
help_topic_id < LENGTH(keep_watch_route.staff_user_id)-LENGTH(REPLACE(keep_watch_route.staff_user_id,',',''))+1
mysql拆分字符串
最新推荐文章于 2023-11-30 21:41:39 发布