<select id="getFormatList" resultMap="FormatListRVO">
<![CDATA[
SELECT
T.FORMAT_ID formatId,
T.FORMAT_NAME formatName,
T.START_PLACE startPlace,
T.END_PLACE endPlace,
T.PLAY_DAYS playDays,
T.CREATE_TYPE createType,
date_format(R.START_DATE, '%Y/%d/%m') startDate, //时间格式转换
R.DEADLINE deadLine,
R.END_DATE endDate
FROM
t_f_format T
LEFT JOIN
t_f_release R ON T.FORMAT_ID = R.FORMAT_ID AND R.DELFLAG = 0
WHERE T.DELFLAG = 0
]]>
<if test="formatName != '' and formatName != null">
AND T.FORMAT_NAME LIKE CONCAT('%',#{formatName},'%') //模糊查询
</if>
LIMIT #{begin},#{count} //分页
</select>
mysql myBatis 模糊查询的写法
最新推荐文章于 2023-08-22 14:04:06 发布