| From: | Gonzalo V <gvm2121(at)gmail(dot)com> |
|---|---|
| To: | pgsql-students(at)postgresql(dot)org |
| Subject: | select works and not. |
| Date: | 2017-12-07 01:22:56 |
| Message-ID: | CAF40P_3_XTbSszjrsaVP-wbpHArAsaomshRqSR7x1PipfH9pig@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-students |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin+ Martyn | 2017-12-07 01:33:05 | Re: select works and not. |
| Previous Message | Simon Riggs | 2017-04-06 19:33:40 | Re: [HACKERS] [GSoC] Push-based query executor discussion |