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

Поиск
Список
Период
Сортировка
От Kevin+ Martyn
Тема Re: [pgsql-students] select works and not.
Дата
Msg-id CAOGf-iEqfmy_1cEMy4DOvyf1cXPudLuK_v70fwDDij=L3GQJuQ@mail.gmail.com
обсуждение исходный текст
Ответ на [pgsql-students] select works and not.  (Gonzalo V <gvm2121@gmail.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Gonzalo V
Дата:
Сообщение: [pgsql-students] select works and not.