To delete a hyperlink from a database in bulk

If you delete hyperlinks in the database, the link URLs are not the same, it is best to use SQL

Reply to discussion (solution)

Do not know how you save, how to help you?

If you delete a hyperlink in the text, you have to use regular expressions.

Can give a detailed query statement, thank you very much!

or bulk clear HTML format is OK, please help AH ~

Explain what the database is, the version, and then at least give a ballpark figure?

Clear HTML format? Does this mean that the HTML and text in a column are mixed?

Explain what the database is, the version, and then at least give a ballpark figure?

Clear HTML format? Does this mean that the HTML and text in a column are mixed?

mysql5.0 News table has a field content is stored in HTML format, want to clear all HTML tags, if a img or something, only keep plain text, thank you!

