Search and replace on a MySQL table?

[DWZ]

Is it possible to make phpMyAdmin, or something else to do a search and replace on some text in a database...

You see, I want it to look at my vB database, go into the smilie table, then find anything that says http://www.consoleradar.com/forums/ and replace it with nothing, blank text.

So yeah, when It finds say http://www.consoleradar.com/forums/images/smilies/smile.gif I want it to change to images/smilies/smile.gif

I could do it manually, It's just a lot of smilies to go through...

so yeah, is there some SQL command I can use or something?

Thanks

Alan (DWZ)