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 intl_localidades INNER JOIN intl_zonas ON (intl_localidades.codigo_zona = intl_zonas.id) INNER JOIN intl_paises ON (intl_zonas.codigo_pais = intl_paises.id) INNER JOIN intl_province_mapping ON (intl_localidades.id = intl_province_mapping.location_code) WHERE ((intl_province_mapping.provider_code = 25) and (intl_province_mapping.provider_city_code = 'S\'ARENAL')) Diana Castillo Global Reservas, S.L. C/Granvia 22 dcdo 4-dcha 28013 Madrid-Spain Tel : 00-34-913604039 Fax : 00-34-915228673 email: [EMAIL PROTECTED] Web : http://www.hotelkey.com http://www.destinia.com
