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"');

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
The comment language code.