Replace string in Field Value with SQL

Replace string value in MySQL

UPDATE table_name 
SET field = replace(field, 'string-to-find', 'string-that-will-replace-it');

Cek Double Entri Field with SQL

Cek Double Entry

SELECT field_name, COUNT(*) c FROM table_name GROUP BY field_name HAVING c > 1