From: | "Kevin+ Martyn" <martynkp4(at)gmail(dot)com> |
---|---|
To: | Gonzalo V <gvm2121(at)gmail(dot)com> |
Cc: | pgsql-students(at)postgresql(dot)org |
Subject: | Re: select works and not. |
Date: | 2017-12-07 01:33:05 |
Message-ID: | CAOGf-iEqfmy_1cEMy4DOvyf1cXPudLuK_v70fwDDij=L3GQJuQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-students |
There may be characters that don't show in the data. Such as two blanks.
Maybe you can isolate it by doing your like clause something like
'...1031%CHIA' then '...1031%BARNECHIA'...
Corrections welcome
On Dec 6, 2017 8:23 PM, "Gonzalo V" <gvm2121(at)gmail(dot)com> wrote:
Good day
please i need help on this search, i am stuck by days!
select * from ventasprueba v
where v."DIRECCION" like 'AVDA. LA DEHESA #1445
<https://maps.google.com/?q=AVDA.+LA+DEHESA%C2%A0+%231445&entry=gmail&source=g>,
LOCAL 1031, LO BARNECHEA'
it gives me nothing.
but if i delete ,LO BARNECHEA
select * from ventasprueba v
where v."DIRECCION" like 'AVDA. LA DEHESA #1445
<https://maps.google.com/?q=AVDA.+LA+DEHESA%C2%A0+%231445&entry=gmail&source=g>,
LOCAL 1031%'
it works!.
i need to make that select with the complete string but it doesnt work.
can you help me
Saludos,
Gonzalo
From | Date | Subject | |
---|---|---|---|
Previous Message | Gonzalo V | 2017-12-07 01:22:56 | select works and not. |