delete smilies

[Chad]

I have about 60 emoticons that I wish to reduce to about 35-40. Those that I delete, I can only assume they will show up as X images in the past posts? If so, is there a way to prevent that?

[Jose Amaral Rego]

Read the following link

http://www.vbulletin.com/forum/showpost.php?p=1348541&postcount=1

Create and test backup before using this query.
# replace old_text with characters with red 'x' and new_text with either default smilie characters or empty space between 'quotes'

UPDATE post
SET pagetext = REPLACE(pagetext,'old_text','new_text')