Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
February 27, 2006, 4:47 pm
rate this thread
I need to select records ordered by a string column. But when I order
by with data containing an underscore, the result is not as expected.
Following probably will make the problem clearer:
When I try this on Oracle:
SELECT LEAST('aa','ab','a_') FROM DUAL;
The results is 'a_'
but when I try this on MySQL
The results is 'aa'
whereas I would actually need/expect "a_".
For all other _ characters (like "-". "%") it works fine just as
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum