query search for and replace with in mysql database code example
Example: search for replace in mysql
UPDATE products SET
productDescription = REPLACE(productDescription,'abuot','about');
UPDATE products SET
productDescription = REPLACE(productDescription,'abuot','about');