char replacement

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'.
Thanks for your ideas
VooDoo

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.

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.

VooDoo <voodoonet38@free.fr> wrote:
> 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...

Well, if the problem is indeterministic, you will neeed voodoo.

Yours,
Laurenz Albe

;)
I sorted it out using php & an update.
Thanks
VooDoo
"Laurenz Albe" <invite@spam.to.invalid> a écrit dans le message de news:
1131093989.752711@proxy.dienste.wien.at...
> VooDoo <voodoonet38@free.fr> wrote:
>> 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...
>
> Well, if the problem is indeterministic, you will neeed voodoo.
>
> Yours,
> Laurenz Albe