when using MyBatis, there is a problem with an incomprehensible SELECT statement.
<select id="getHotelList" resultType="com.genius.travelline.product.entity.Hotel">
SELECT
a.id AS "id",
a.title AS "title",
a.province AS "province",
a.city AS "city",
a.level AS "level",
b.url AS "imgUrl"
FROM
product_hotel_base a
LEFT JOIN
product_hotel_img b ON b.hotel_id = a.id
WHERE
a.del_flag = 0
AND a.province = ""
AND a.city = ""
</select>the above statement is written in MyBatis, but the query result is empty.
SELECT
a.id AS "id",
a.title AS "title",
a.province AS "province",
a.city AS "city",
a.level AS "level",
b.url AS "imgUrl"
FROM
product_hotel_base a
LEFT JOIN
product_hotel_img b ON b.hotel_id = a.id
WHERE
a.del_flag = 0
AND a.province = ""
AND a.city = "" the above statement is written in Navicat, and the query result is normal.
the two sentences are almost identical, but why are the results different?