Any mySQL/MariaDB gurus around? Need help with query
I'm looking to update from using Emotify plugin to using Emoji Extender.
I've got the plugin side working fine.
For existing posts, I need to replace, for example, ;lol with :lol:
However, I keep running into an issue that I assume relates to the semicolon.
A test query using this syntax:
UPDATE `gdn_comment` SET `Body`= REPLACE (`Body`, 'banjax', 'banjacks'), WHERE `Body` LIKE '%banjax%'
works as expected
throws an error.
I've looked on the Interwebby, and there is advice to escape the ; or that you don't need to.
and variations thereof, with no luck.
If anyone has any suggestions I'd be grateful.
It's not mission critical, but I would like to know how to do it if possible.