Re: how to ignore case

[Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx>]

On Thu, 2005-05-19 at 14:20, Scott Marlowe wrote:

> or REGEX:
> 
> select * from table where lower ~* '.*abc.*';

That second one should be:

select * from table where somefield ~* '.*abc.*';

either too much or not enough coffee