Re: Query using 'LIKE' returns empty set

[Michael Lewis]

You need the wildcard character at front and back.

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