Hi,
select * from t1

ordno qty
             1
             3
             5
'aaa'     18
'bbbbb'  20

select * from t1 where ordno='  ' or ordno>'  '
ordno qty
             1
             3
             5
'aaa'     18
'bbbbb'  20

select * from t1 where ordno>='  '
ordno qty
'aaa'     18
'bbbbb'  20

mysql version 5.1.44 still with the bug

Best regards!
Shuming Wang

Reply via email to