Change Smilie Replacement Text
 

If I want to change the replacement text for a smilie without breaking the posts where it was used previously, do I have to do anything other than a search and replace of the post table?

So for example I have a smilie named :puppy: that points to puppy.gif, and I want to change the replacement text to :dog: without breaking the posts where :puppy: was used. Can I just change the smilie in the ACP and then search the post table for :puppy: and replace it with :dog:?

If so, what would that query look like?

Google gave me the answer I was looking for. The query to find and replace text in posts is:

UPDATE post SET pagetext = REPLACE (pagetext,'search_for_this','replace_with_this');