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
