Hello everyone,

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.

Giuseppe