sql if写法备忘

以下为实例
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},’%’))