mysql upper in where clause ?

[liveaday]

select * from sites where upper(url) = lower('HTTP://www.mysite.com')

can anyone tell me why does the above sql statement return results when it should return no results???

i was trying this where clause : where upper(url)=upper('$url'), but it doenst seem to work right...

what am i doing wrong and how can i do the latter where clause ?

thanks

[sarahk]

Hi there

I get the same thing on my hosted site so I'm assuming mysql has case sensitivity turned off. I know Microsoft SQL allows that so it's likely the good folk at MySQL thought they'd add it to their product.

If you can't live with it then check with your host or find out how to change it.

Your syntax seems to be fine.

[MrAlaska]

This is documented in the MySql manual, you can use the binary operator to force case sensitive searches.

try this:

select * from sites where binary upper(url) = lower('HTTP://www.mysite.com')