convert accentuated characters to none accentuated

[Matth_S]

Hi,

I want to select rows without taking account of the accentuated characters. The aim of this is to get the results in a search engine, even if the user forgets to put an accent, or put an accent where he should not.

For example, I have a field with the value "publicité" , I want to get this result even if the user searchs the word "publicite".
I can't simply use a REPLACE(), because, this problem occurs with any kind of accentuated character (é,è,à,ô,â,etc), so I would have to nest a lot of REPLACE functions and I fear the query would be big enough. Do you know if there is a better way to do that ?

[Matth_S]

Ok, I forgot to mention, but I know it's possible with a simple 'like' , but I would have prefered to have something different than
'name like '%$word[1]%' AND name like '%$word[2]...' , depending on how many words the user has written in his query. I assume that having a lot of "like '% %'" in a query isn't the best thing to do either ?