Mysql 查询问题

Question

select AUDIT_ID,RELATE_ID from tbl_audit where RELATE_ID = 1009036结果是1010301    1009036-CANCEL1111903    1009036-CANCEL1111907    1009036-CANCEL1117209    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'