> 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')) >
Hi there , i've had a similar issue in mysql4 fulltext match against search, a something like chris's wouldnt come up ! you may have to split at the quote and then join it together , i'd be interested how you go i think a like will pick it up some LIKE "%S'ARNEL%" should pick it up -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
