Search Postgresql Archives
Re: Query using 'LIKE' returns empty set
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Query using 'LIKE' returns empty set
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Thu, 29 Aug 2019 11:04:34 -0600
Cc
: PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
35011785-7cb6-59a7-550f-24b8ff6e9a0a@gmail.com
>
References
: <
alpine.LNX.2.20.1908290903030.2953@salmo.appl-ecosys.com
> <
35011785-7cb6-59a7-550f-24b8ff6e9a0a@gmail.com
>
You need the wildcard character at front and back.
select * from fish_counts where stream_tribs ilike '
%
Nehalem
%
';
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
Query using 'LIKE' returns empty set
From:
Rich Shepard
Re: Query using 'LIKE' returns empty set
From:
Rob Sargent
Prev by Date:
Re: Query using 'LIKE' returns empty set
Next by Date:
Re: Query using 'LIKE' returns empty set [FIXED]
Previous by thread:
Re: Query using 'LIKE' returns empty set
Next by thread:
Re: Query using 'LIKE' returns empty set [FIXED]
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
