var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: replace special characters in sql query
I have a problem on getting some data with a simple sql query.
On my website What's the weather in your city?, for example in this page What's the weather in ?, I need to display all letters without accent and I want to make a select like on the records, replacing their accents and special characters.
In a nutshell something like this:
SELECT * FROM cities WHERE REPLACE(name, <all special characters with equivalent without accent>) LIKE '%DA%';
so if I find "à" I want to replace it with "a" and "è" with "e" and etcetera, all in one select query. Is it possible?
Thanks for your responses.
Tags for this Thread