select like to return a sting without line break

Question

select like to return a sting without line break

Navigation

#1 by (1 votes)

1

I'm using the following query:

select distinct con_destinatario from tab_conhecimento where con_destinatario like '%CALLE%' order by con_destinatario;

and I get several results of this type:

    A.S. OPORTUNIDADES Y NEGOCIOS S.R.L.
    CALLE TTE. ROJAS SILVA CASI REDUCCION MELODIA
    VILLA HAYES - PARAGUAY

I would like the query to be considered only the first line before the line break if someone is enabled?

mysql sql

asked by anonymous 21.08.2014 / 21:06

1 answer

Select only 1 record with equal category and hidden in others How to get a value from a list

score 1 · Accepted Answer

1

I GOT IT SO:

select distinct con_destinatario from tab_conhecimento where con_destinatario like '%CALLE%' AND con_destinatario NOT LIKE '%
%CALLE%' order by con_destinatario;

Thank you.

21.08.2014 / 21:19