Re: SQL Question about like
От
Michael Nolan
Тема
Re: SQL Question about like
Дата
Msg-id
CAOzAquL2foLbjr0zMr83N36ccy5mzD62ghaj=c1BBPfJb3GEoQ@mail.gmail.com
Ответ на
Re: SQL Question about like (Adrian Klaver)
Список
Дерево обсуждения
SQL Question about like "pgml@gmx.de" <pgml@gmx.de>
Re: SQL Question about like Adrian Klaver <adrian.klaver@aklaver.com>
Re: SQL Question about like Ron <ronljohnsonjr@gmail.com>
Re: SQL Question about like Michael Nolan <htfoot@gmail.com>
Re: SQL Question about like Adrian Klaver <adrian.klaver@aklaver.com>
Re: SQL Question about like Michael Nolan <htfoot@gmail.com>
Re: SQL Question about like Michael Nolan <htfoot@gmail.com>
I usually use something like trim(field) like 'pattern'. Eliminates the need for the wildcard at the end. I find I use the ~ operator more than 'like' though.
--
Mike Nolan
On Mon, Aug 10, 2020 at 12:24 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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.klaver@aklaver.com
В списке pgsql-general по дате отправления
