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