In an SQL table replace specific values in a column

table= The table name
2x field= The column name by the data resides
Original value = The string to search
New Value = The string to be replaced

UPDATE `table` SET `field` = replace(`Ffieldld`, 'Original value', 'New Value');

Leave a Reply

Your email address will not be published. Required fields are marked *