Replacing symbols in mysql table via phpmyadmin

Note on replacing symbols in the database table. Go to the execution of the request and drive in the following

UPDATE table SET column = REPLACE(column, 'old word', 'new word');

For example, we need to replace the ID with a class in a specific table. Our request will be something like this

UPDATE `body` SET `body_value` = REPLACE(`body_value`, 'id="but"', 'class="buttons"');

You can also try to replace links that share a common path to build a specific search pattern. But this method doesn’t always work and if you use Mysql 8:

UPDATE node__body SET body_value = REGEXP_REPLACE(body_value, '<a href="https://www\.domain\.com/production/[^"]*">[^<]*</a>', '') WHERE body_value LIKE '%<a href="https://www.domain.com/production/%';