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