Thread: [pgsql-students] select works and not.
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, 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, LOCAL 1031%'
it works!.
i need to make that select with the complete string but it doesnt work.
can you help me
Saludos,
Gonzalo
Gonzalo
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@gmail.com> wrote:
Good dayplease i need help on this search, i am stuck by days!select * from ventasprueba vwhere v."DIRECCION" like 'AVDA. LA DEHESA #1445, LOCAL 1031, LO BARNECHEA'it gives me nothing.but if i delete ,LO BARNECHEAselect * from ventasprueba vwhere v."DIRECCION" like 'AVDA. LA DEHESA #1445, LOCAL 1031%'it works!.i need to make that select with the complete string but it doesnt work.can you help meSaludos,
Gonzalo