On 8/10/20 9:37 AM, p...@gmx.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.kla...@aklaver.com


Reply via email to