Mysql 查询问题

Question

select AUDIT_ID,RELATE_ID from tbl_audit where RELATE_ID = 1009036

结果是

1010301    1009036-CANCEL
1111903    1009036-CANCEL
1111907    1009036-CANCEL
1117209    1009036

为啥查出来是这样的？能讲述一下原理么

10090361查不出

-1009036查不出

Answer 1

select AUDIT_ID,RELATE_ID from tbl_audit where RELATE_ID like '%1009036%';

Answer 2

你应该用like，where RELATE_ID like '%1009036'