Change mass smilie path

Hi does any one know of a MYSQL way of changing the smilies paths i have over 100.

In the database my current smilies path is
I would like to change them to

Any thoughts or is there an easer way i have missed?



XenForo moderator
Staff member
To replace post content you can run this query.

UPDATE xf_post SET message = REPLACE(message, 'old_path', 'new_path')

Just replace old_path and new_path as necessary.

Take a backup first though, just in case.
I got it! My dum fault i was looking at the wrong database.

UPDATE xf_post SET message = REPLACE(message, '/styles/default/xenforo/smilies/', '')

Al sorted thanks Brogan. (y)