1、前提
试卷表有个字段,保存的是题目表的题目集合
2、查询
现在需要将前端传入的题目集合,进行题目表的查询
3、 MyBatis编写
<!--根据题目集合获取题目列表-->
<select id="getTopicListByTopicSet" parameterType="string" resultType="Topic">
select
<include refid="TopicColumns"></include>
from jy_topic a
where a.id in (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(#{topicSet}, ',', help_topic_id + 1), ',', -1) AS num
FROM mysql.help_topic
WHERE help_topic_id <![CDATA[<]]> LENGTH(#{topicSet}) - LENGTH(REPLACE(#{topicSet}, ',&#