I am trying to replace a couple of quotes with single quotes in my database. The values I am trying to replace are all in the form of "xyz", so the code I am trying to run looks as following:
UPDATE catalog SET description = replace(description,""xyz"","'xyz'");
However this will throw an error and I would therefore like to know how to batch replace every "xyz" with 'xyz'.
Thanks in advance!