thanks, i have read this section:
http://dev.mysql.com/doc/refman/4.1/...functions.html

I have found this:
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'

but the problem is that i don't know exactly the field. The path where i
need to change the c character is not always the same...

"Christian Kirsch" <ck@bru6.de> a écrit dans le message de news:
436a51b9$0$21941$9b4e6d93@newsread2.arcor-online.net...
> VooDoo wrote:
>> Hi,
>> I have a table with a field that contains a file
>> path(www/docs/.../.../...)
>> Some of the path contain this characters 'é' or 'è'.
>> How can i do an update on this table to replace only the characters 'é'
>> or
>> 'è' by a 'e'.
>
> Check the Fine Manual at dev.mysql.com/doc, section on string functions.