How to automatically add to html tags in MySQL?

Question

MySQL

In the database, you need to add to all html IMG tags, in addition to the standard ALT, also TITLE. How to automatically create for each IMG tag that has ALT also a TITLE tag with similar text content? Tools console, phpmyadmin, notepad++

Answer 1

Write a script that will take your data from the database, process it with a regular expression and immediately update it in the database.

Answer 2

For example, make a dump, go through it with sed, delete the original base, upload the edited dump back.

Answer 3

Thank you, I can make a dump and open it with an editor. I would like specifics what to write without php - because. The procedure is one-time, I think the script will be less. I can download the dump and open it in an editor. Either a query to the database, or a regular expression in N ++, that's the problem.