In order to make this quicker, I'm trying to remember how to do a partial string replacement, with the combination of a wild-card that needs to remain unchanged.
It's for an add-on that I'd like to update quickly, the table is xf_mood
What I have is a bunch of entries like so
I need to change
While still keeping the ending images unchanged.
So the end result after running the command would be changing these
It's been a while since I've done this and I'm trying to remember how to do only a partial replacement string, with an unchanged wild card.