Re: SQL Question about like

On 8/10/20 9:37 AM, pgml(at)gmx(dot)de wrote:
> Hello,
>
> my SQL question is, why psql doesn't return the record?
>
> create table lll (text char(100));
> insert into lll (text) values ('10% - Ersthelfer');
>
> select * from lll where text like '10% - Ersthelfer';
>
> Other databases (Maria, SQL Server, YARD) do this.
> What can I do in pg, to get the result?

A little documentation goes a long way:) :

https://www.postgresql.org/docs/12/functions-matching.html#FUNCTIONS-LIKE
>
> Thank you and best regards, Martin
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com