... for quick tweaks to the database values after a migration.
-- Replace stringtofind with the string you want to find
-- Replace stringtoreplace with the string you want to replace with
-- REPLACE ...
... find all the articles that need this change:
SET @stringtoFind='';
SET @stringtoReplaceWith='';
SELECT
`id` ,
`title` ,
IF(LOCATE( @stringtoFind, REPLACE(`content_column`, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.