Praktische SQL Schnipsel / Practical SQL Snippets (MySQL)

UPDATE network_users REPLACE('www.mysql.com', 'w', 'Ww');

UPDATE `mytable` SET `same_field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text') WHERE some_or_other_fieldname LIKE 'MyUniqueString %';

UPDATE `mytable` SET `my_same_field` = `myotherfield` WHERE my_same_field LIKE 'MyUniqueString %';

UPDATE `mytable` SET `myfield` = replace(myfield, 'MyUniqueString-', '');

Import Data Dump:

mysql -u DbUserName -p DbName < DbDump.sql