It depends on what language you are using to send the query.
If you are using the shell, 'S\'ARENAL' parses to 'S'ARENAL' before it
is sent to the server.
You will need to escape the escape character.
'S\\'Arenal'
or maybe even 'S\\\'Arenal' or 'S'ARENAL'
It depends on how many parsers scan
> Hi, How can I make a query that looks for a city that has a " ' " in
> the name? For instance, I am looking for the name S'ARENAL, but the
> query below does not work:
>
> SELECT intl_localidades.id, intl_localidades.codigo_pais,
> intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es
Hi, How can I make a query that looks for a city that has a " ' " in the name? For
instance, I am looking for the name S'ARENAL, but the query below does not work:
SELECT intl_localidades.id, intl_localidades.codigo_pais,
intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es FROM
in
