making search better with LIKE
Posted on 2011-09-15
Hi, i want to search the content on some rows. i have an sql query that uses like but some times is not working since in Portuguese we have a lots accents like á, â, à. so i want the like behave like this:)
if someone is searching for the work: especialização
the like should return results for all: especializaçao, especializacão, especialização, and also the usual results for like: testespecialização.