MyBB Community Forums

Full Version: SQL Query
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello I recently made a CDN so I wanted to move all my current urls of images on namestyles to the new urls, they all end in the same image number and extension but I wanted to replace example.com/z/imagenumber.imageext to cnd.example.com/i/imagenumber.imageext ...
Could someone give me a hand real quick?
What I tried: UPDATE mybb_usergroups SET namestyle = 'https://cdn.example.com/i/*.*' WHERE namestyle = 'https://example.com/z/*.*'
I have more code before this line such as <img and stuff I ONLY want to replace the url of image