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

[Rich Shepard]

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