Hi,
Can someone help me how to do a search independent of accents?
im trying to do a search query and display records depending of the search text
i want to search the words (in pagetitle column) "cancer" or "cáncer" and get the same result. The word cáncer is located in DB pagetitle and is displaying all kind of result, but when i search for cancer(no accents), no results at all.
This query is working well, but not for cáncer-cancer or any other variation (hepático-hepatico)
SELECT msc.id, isfolder, uri, class_key,tmplvarid, value, msc.pagetitle
FROM `modx_site_content` AS msc
INNER JOIN `modx_site_tmplvar_contentvalues` AS mstc
ON msc.id = mstc.contentid
WHERE(LOWER(pagetitle) like '".$search."%' )
AND tmplvarid IN(4,28)
AND isfolder=0 AND mstc.value = 'si' AND template IN(4,8,184,117,136,134,125,33,34,90,144,145,146,147)
LIMIT 100"
Thanks for your time