以下为实例
SELECT
province_code,
province_name,
city_name,
city_code,
city_id
FROM
province_city
WHERE
1 = 1
AND
IF(#{0} = null, 1 = 1, province_city.province_name like concat(‘%’,#{0},’%’))
AND
IF(#{1} = null, 1 = 1, province_city.city_name like concat(‘%’,#{1},’%’))
sql if写法备忘
最新推荐文章于 2024-06-02 20:51:27 发布
扫一扫
396
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
