SQL help

[moon 111]

I have a table. One of the fields is title. I want to sort it by title in LOWERCASE becasue some are in lower case and others in uppercase and the lower case ones are gettting listed on the top when I sort them.

 

This is my code now:

SELECT * FROM site ORDER BY title ASC

 

Could I write something like this?

SELECT * FROM site ORDER BY LOWER(title) ASC

 

thanks

[Barand]

surely it would be quicker to try it than post here and wait for a reply

[aschk]

Doesn't it depend on your collation and charset?

Instead of lower() i think you can use binary() , and lower might not differentiate between collations, i.e. SQL = sql . Just a guess, give it a try of course to find out.

[Barand]

Binary will force a normally case insensitive search to be case-sensitive.

[aschk]

Doesn't that mean it'll work in this situation? Maybe I should do a test myself

[Barand]

Binary is to distinguish between UC and LC. That's the exact opposite of what is wanted in this case

[aschk]

Ah yes, just re-read the question. Whoops!