strtoupper or strtolower

[Anon]

Hi,

How can I tell MySQL, that I'm don´t care a damn, about upper- and lowercase.

//Ulrik Q K

[alanl]

RTM....

MySQL by default is case insensitive.

http://www.mysql.com/doc/C/a/Case_sensitivity.html

Cheers,
Alan

[Anon]

It´s not true!
But the text I have in the col. are a.g. "FiRWrrtY", can that be the problem?

Can I use strtoupper(col_name) or something like that???
PHP don´t understand col_name then!

Please Help

//Ulrik Q K

[alanl]

Strange! OK, do something like:

$sql = "SELECT stuff FROM table WHERE UCASE(col) = '".strtoupper($col)."'";

Hope that helps,
Alan

[Anon]

THANKS ALAN L!