search/select case-insensitivly.

I want a PHP program to search case-insensitivly.

for example:
select Name from mytable where Name = '$Name';

Here $Name is what users' input maybe JOHN, john. How to let it match John
in table and find that record?

Thanks.

Zhidian Du

_________________________________________________________________
Surf the Web without missing calls! Get MSN Broadband.
http://resourcecenter.msn.com/access/plans/freeactivation.asp