MySQL Knowledge Base
Replace Function
Syntax
UPDATE table_name SET column_name = REPLACE(column_name, 'from','to');
Example
mysql> update gym__2017__curr__ssm SET is_max = REPLACE(is_max, '1', 'yes');
NULL
UPDATE table_name SET column_name = REPLACE(column_name, 'from','to');
mysql> update gym__2017__curr__ssm SET is_max = REPLACE(is_max, '1', 'yes');
NULL