Batch delete hyperlinks in a database

Batch delete hyperlinks in a database. if you delete a hyperlink in a database, the link URL is not the same. it is best to use SQL

Reply to discussion (solution)

I don't know how you saved it. how can I help you?

If you delete a hyperlink in text, you must use a regular expression.

Can you give me a detailed query statement? thank you very much!

You can also clear the html format in batches. could you please help me ~

Which database is the version and at least give the approximate data?

Clear html format? Is html and text mixed in a column?

Which database is the version and at least give the approximate data?

Clear html format? Is html and text mixed in a column?

In the mysql5.0 news table, the content field is in html format. to clear all html tags, if a img or something, only plain text is retained. thank you!