Bit of a conundrum today. I implemented some query string into my website so I'd like to retroactively update all my previous (600+) posts to update specific hyperlinks to include this query string.
Example, most of my posts have code like this:
<a data-name="Dish Washer">Dish Washer</a>
Would it be possible to forcefully update all posts to change the links to this:
<a data-name="Dish Washer" href="/items/?item=Dish Washer">Dish Washer</a>
The hard part is that obviously there is more than just "Dish Washer" and each post contains numerous amounts of items.
I'm trying to figure out if it can possible be done through MySQL but I can't for the life of me figure it out.