PHP MyAdmin – SQL command, Replace data in the database

It comes every now and again before, that a domain transfer, image_link a change or similar. in many places such as change in the transaction must email.
This situation we had just, that the logo, which will be sent emails with the transaction was in another place and it is now over 20 had to be changed emails.

Of course, this can be done for someone in the back of someone transaction emails. But if it is a 1:1 Exchange, d.h. always the same string is compared to another, always the same- String to be replaced, This is done most conveniently through the database.

First, that is, in PHP phpMyAdmin or similar. changed, the database is selected and then under the tab “SQL” The following command is entered (Here on the table in the text should be replaced core_email_template:

UPDATE core_email_template SET template_text =
replace(template_text, 'Text to be searched', 'Text with the found text will be replaced')

This gives the following structure:

UPDATE NamederTabelle SET NamedesFeldes =
replace(NamedesFeldes, ‘ZusuchenderText‘, ‘Replacement text‘)

This may at one point or another help much.

As always, the Note: Always be sure, was man tut. A backup BEFORE surgery is useful in the DB.

It comes every now and again before, that a domain transfer, image_link a change or similar. in many places such as change in the transaction must email. This situation we had just,...