mybatis查不出数据,但是把sql粘出来就能查到

Question

19:26:09,929 DEBUG Statement:134 - {conn-110001, pstmt-120000} Parameters : [
"13800000000"
,
"13800000000"
]
19:26:09,930 DEBUG Statement:134 - {conn-110001, pstmt-120000} Types : [VARCHAR, VARCHAR]
19:26:09,937 DEBUG Statement:134 - {conn-110001, pstmt-120000} executed. 8.500325 millis.
select heu.app_user_id,heu.im_user_id,hu.avatar,hu.sex,hu.nick_name from
h_user as hu LEFT JOIN h_im_user as heu on hu.id = heu.app_user_id
WHERE 1=1

            and hu.nick_name like CONCAT('%',
 "13800000000"

,'%')
or hu.user_name = ? or hu.mobile = ?
19:26:09,945 DEBUG ResultSet:139 - {conn-110001, pstmt-120000, rs-150000} open
19:26:09,954 DEBUG ResultSet:139 - {conn-110001, pstmt-120000, rs-150000} Header: [app_user_id, im_user_id, avatar, sex, nick_name]
19:26:09,982 DEBUG queryUserForFriend:142 - <== Total: 0

Answer 1

你的控制台上面调用那个sql语句完整的是什么，你把那个运行下试试。不要看那个sql语句，看调用的那个完整的sql。