search and replace mysql query code example

Example 1: search for replace in mysql

UPDATE products SET 
productDescription = REPLACE(productDescription,'abuot','about');

Example 2: find and replace database table phpmyadmin

update TABLE_NAME set FIELD_NAME =
replace(FIELD_NAME, 'Text to find', 'text to replace with');