Query without case?

[csousley]

Can I do a query that will match a variable of any case combination? Say MySQL info looks like this:

id = 1 / name = John

I need a query that will match John as:

John
john
joHn
JOHN

and so on. I tried a like query, but that doesn't seem to be working?

select * from db where name like 'john'

Any thoughts? Thanks.

[LordShryku]

$var = "John";
$lookFor = strtolower($var); // make it lower case
$sql = "SELECT * FROM table WHERE lower(field) = '".$lookFor."'";

[csousley]

That looks good, I'll give it a shot.
Thanks!