search and replace

[diettalk]

Is there a way to search and replace old smilies code in posts?

would I just use...

UPDATE post SET clmName = REPLACE(clmName, 'findText', 'replaceText');

[Logician]

This can help:

http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=709