From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Michael Nolan <htfoot(at)gmail(dot)com>, "pgml(at)gmx(dot)de" <pgml(at)gmx(dot)de> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: SQL Question about like |
Date: | 2020-08-10 17:24:01 |
Message-ID: | 2aa71c20-aac8-fc7a-8b4d-0f334de878f1@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/10/20 10:01 AM, Michael Nolan wrote:
> The problem is your field is fixed length text, change it to
> varchar(100) or text and it works without the wildcard at the end.
That assumes values don't get entered with spaces:
create table lll (text varchar(100));
insert into lll (text) values ('10% - Ersthelfer');
insert into lll (text) values ('10% - Ersthelfer ');
select * from lll where text like '10% - Ersthelfer';
text
------------------
10% - Ersthelfer
(1 row)
select * from lll where text like '10% - Ersthelfer%';
text
---------------------
10% - Ersthelfer
10% - Ersthelfer
I have seen that enough times to default to using wildcard if I am
really looking for LIKE not =.
> --
> Mike Nolan
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Brusselback | 2020-08-10 17:38:02 | Re: UUID or auto-increment |
Previous Message | Stephen Frost | 2020-08-10 17:16:29 | Re: UUID or auto-increment |