Home > mailing lists

Re: Query using 'LIKE' returns empty set - Mailing list pgsql-general

From	Michael Lewis
Subject	Re: Query using 'LIKE' returns empty set
Date	August 29, 2019 20:04:34
Msg-id	CAHOFxGqFn2d_FGgHT+UenWMTxG1p7F9DhBd102kpm8r3u+JQ+g@mail.gmail.com Whole thread Raw
In response to	Re: Query using 'LIKE' returns empty set (Rob Sargent <robjsargent@gmail.com>)
List	pgsql-general

You need the wildcard character at front and back.

select * from fish_counts where stream_tribs ilike '%Nehalem%';

From: Rob Sargent
Date: 29 August 2019, 19:58:52
Subject: Re: Query using 'LIKE' returns empty set

From: Rich Shepard
Date: 29 August 2019, 20:16:23
Subject: Re: Query using 'LIKE' returns empty set [FIXED]