Have a webpage with 2000 articles ?
Need to replace a certain keyword with a new one?
Use the string below.
UPDATE tablename SET fieldname = REPLACE(fieldname, ‘the text you want to replace’, ‘new text goes here’);
Have a webpage with 2000 articles ?
Need to replace a certain keyword with a new one?
Use the string below.
UPDATE tablename SET fieldname = REPLACE(fieldname, ‘the text you want to replace’, ‘new text goes here’);
Nice, thanks for the code. Would you be interested in in sharing links?