# UPDATE Statement Examples

• UPDATE (multiple)
• UPDATE values based on another column in the same table
• UPDATE value(s) using CONCAT()
• REPLACE
• Advanced - Search for a string inside a column and replace

# UPDATE (multiple)

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

# UPDATE values based on another column in the same table

UPDATE table_name
SET column1 = column2
WHERE condition;

# UPDATE value(s) using CONCAT()

UPDATE table_name
SET column1 = CONCAT(column2, '/', column3)
WHERE condition;

# REPLACE

UPDATE table SET column = REPLACE(column, 'find_string', 'replace_string');

UPDATE chapters SET title = REPLACE(title, 'Section', 'Module')
WHERE title LIKE '%Section%';

# Advanced

# Search for a string inside a column and replace

UNTESTED

UPDATE `table_name`
SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')