互联网服务Db2 10.5
关于like语句的一个问题
语句1：SELECT *
FROM TB_SVC_SUBS_HIST A
LEFT OUTER JOIN
DTL_BILL B on A.SUBS_ID=B.SUBS_ID
WHERE A.MSISDN = '13400279142'
语句2：
SELECT *
FROM TB_SVC_SUBS_HIST A
LEFT OUTER JOIN
DTL_BILL B on A.SUBS_ID=B.SUBS_ID
WHERE A.MSISDN like '13400279142'
为何语句1能查出来一条记录，语句2查询结果为空呢？
FROM TB_SVC_SUBS_HIST A
LEFT OUTER JOIN
DTL_BILL B on A.SUBS_ID=B.SUBS_ID
WHERE A.MSISDN = '13400279142'
语句2：
SELECT *
FROM TB_SVC_SUBS_HIST A
LEFT OUTER JOIN
DTL_BILL B on A.SUBS_ID=B.SUBS_ID
WHERE A.MSISDN like '13400279142'
为何语句1能查出来一条记录，语句2查询结果为空呢？