【MySQL】MySQL查询语句问题，相同的参数，结果却不一样

Question

今天碰到一个奇怪的问题，MySQL参数一样，查询结果却不相同
我写的：

select go.create_time,go.creator,go.org_id from go_order go where go.creator = '6624575078968950784' and go.create_time >= '2020-05-20 20:29' and go.create_time <= '2020-05-20 20:35:59' and go.org_id = '6535717053503664128'

框架自己生成的：

SELECT create_time,creator,org_id FROM GO_ORDER WHERE ((1 = 1 AND CREATE_TIME >= '2020-05-20 20:29' AND CREATE_TIME <= '2020-05-20 20:35' AND CREATOR = binary('6624575078968950784'))) AND (GO_ORDER.ORG_ID = '6535717053503664128')

我的语句可以查询到结果，框架的查询为空，实在想不明白？？？

去掉binary也还是查不到，请问这是为什么呢？？

Answer 1

https://www.cnblogs.com/fanglongxiang/p/12873298.html