On the PostgreSQL function side of things, you could do:
SELECT name FROM mytable WHERE Name ILIKE('$Name');
Hope this helps! :)
Cheers,
Roj Niyogi
niyogi@pghoster.com
pgHoster - PostgreSQL Web Hosting
http://www.pghoster.com
Zhidian Du wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org