Re: Selecting rows having substring in a column [RESOLVED]

On Thu, 29 Aug 2019, Adrian Klaver wrote:

> test=# select * from like_test where  fld_1 ilike '%Winding River%';
>                fld_1

Adrian,

Aha! I thought of 'like' but forgot about ilike. That's exactly what I need.

Thanks very much,

Rich