[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Query using 'LIKE' returns empty set
From:       Michael Lewis <mlewis () entrata ! com>
Date:       2019-08-29 17:04:34
Message-ID: CAHOFxGqFn2d_FGgHT+UenWMTxG1p7F9DhBd102kpm8r3u+JQ+g () mail ! gmail ! com
[Download RAW message or body]

You need the wildcard character at front and back.

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

[Attachment #3 (text/html)]

<div dir="ltr">You need the wildcard character at front and back.<div><br>select * \
from fish_counts where stream_tribs ilike \
&#39;<b>%</b>Nehalem<b>%</b>&#39;;</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]