Mysql>编辑列中所有单元格的值[关闭]

Question

I have this column with paragraphs of text in each cells. Since I learned last time that I can just echo the paragraph without using break tags <br> using the php command nl2br($string), I want to edit the cells and remove any <br> tags inside the values when they are present on each cell.

But doing it manually would take a long time since there are around a thousand of rows. I am wondering how to have it done in a command in mysql if it's possible. I'm logging the mysql database using the command line/SSH.

Update: here's a screenshot I have after accessing it with mysql.

The dsc column of this db table has some <br> tags inside its values. I want to filter them out and delete them for all the cells in the dsc column using a command/query on ssh instead of phpmyadmin (for further learning ssh stuffs).

Answer 1

This will delete all br-tags in column dsc:

update tableName set dsc = replace(dsc,'<br>','');

See https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_replace