Re: [SQL] How to Make Case InSensitive??? - Mailing list pgsql-sql

S.Ramaswamy wrote:

> When I use SQL statements, how can I make it case insensitive. If I
> use
>
>     SELECT * FROM series WHERE NAME='India'
>
> I want to select rows including those where NAME='INDIA' / NAME =
> 'india'
> and so on.
>
> Can someone help me in the above??

     SELECT * FROM series WHERE upper(NAME) = 'INDIA'
                            or
     SELECT * FROM series WHERE NAME ~* '^india$'