Basically, I want to replace every mention of a phrase in my XF forum posts, profile comments, PCs, and so on to something else. Specifically, I want to change every occurrence of:
With * being a wildcard of whatever smiley image comes after.
For what it's worth: pretty much all occurrences of this are wrapped in tags.
Basically, help me out here, which queries would I need to run on MySQL 5.1.52 to do this?