Postgres Pro
Downloads
Home   >   mailing lists

Re: [pgsql-students] select works and not. - Mailing list pgsql-students

From Kevin+ Martyn
Subject Re: [pgsql-students] select works and not.
Date
Msg-id CAOGf-iEqfmy_1cEMy4DOvyf1cXPudLuK_v70fwDDij=L3GQJuQ@mail.gmail.com
Whole thread Raw
In response to [pgsql-students] select works and not.  (Gonzalo V <gvm2121@gmail.com>)
List pgsql-students
Tree view
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 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

pgsql-students by date:

Previous
From: Gonzalo V
Date:
Subject: [pgsql-students] select works and not.