How to edit mysql table data by mask?

Question

MySQL

There is a mysql table in it there is a field in which text and html code are mixed. What is the best way to remove all html leaving only the text? Records about 10k.

Answer 1

a table - it usually consists of fields ... It is not clear on your question - everything is in one field or in different ...

Answer 2

Let's say this:
$text = preg_replace("/<(.*?)>/ism", "", $text);