In article <1163105789.314191.279110@h54g2000cwb.googlegroups .com>,
yankeerivera@yahoo.com writes:

> There is certainly 1 record in MSG where MSG.ORDER_REF =
> '20061108/RAPTEST/RDL611004643'

> Why should MySQL not return it for the first query?

Probably because your order_ref ends with some whitespace.