https://blog.csdn.net/qq_36800514/article/details/115380100
-- 阅读权限 全239 部分9
select * from hljtxeip_institution where state = 1 and deleteState = 0 and permissionType = 1
SELECT
*
FROM
hljtxeip_institution as a
JOIN (
SELECT
substring_index( substring_index( '12,13,14,112,772,280,1115', ',', help_topic_id + 1 ), ',',- 1 ) AS sub_name
FROM
mysql.help_topic
WHERE
help_topic_id <(
length( '12,13,14,112,772,280,1115' )- length(
REPLACE ( '12,13,14,112,772,280,1115', ',', '' ))+ 1 )
)as b
on a.post like concat(b.sub_name, '%')
标签:help,772,mysql,如何,1115,112,280,like From: https://www.cnblogs.com/l20211103/p/17748526.html