Replacing every £ with &pound?

[enterthe@walla.com]

Hi,

I'd like to replace every instance of £ with £ in a text field
in my database. The field contains text and £ will be one character
amongst many. Is this possible?

Enter

[Aggro]

Re: Replacing every £ with &pound?

enterthe@walla. com wrote:
[color=blue]
> I'd like to replace every instance of £ with £ in a text field
> in my database. The field contains text and £ will be one character
> amongst many. Is this possible?[/color]

Try REPLACE():

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

( I hope I don't need to say, that backup your valuable data, before
trying anything that affects whole table. )