SELECT whatever FROM wherever WHERE lower(yourfield) = 'this';
You can do it with a case inseneitive regex search but they can't use
indexes and can become very slow on large tables..
SELECT whatever FROM wherever WHERE yourfield ~* 'this';
lower() does leak a bit of memory from what I've hear
Joern,
select myfield from tablea where lower(myfield) = 'mysearch';
or
select myfield from tablea where myfield ~* 'mysearch';
Troy
>
> Hello together,
>
> how can I handle case insensitive search in a table?
>
>
>
> --
> Linux is like wigwam - no windows, no gates, apache inside.
> In
