Query to remove leading slash from all smilies?

Kevin

Well-known member
Anybody know of a way to do a query I could run to remove a leading slash "/" from all XF smilie image paths? I know I can do it through the ACP and/or the table directly but if there was a way of doing it through a query that'd make life easier? :whistle:

For curious, I'm moving some test installs around and the new location for some of them is buried deep in sub-folders so the leading slash messing up the URL image paths.
 
Top Bottom