SQL replace replacement character Function

This article introduces a very practical function replace in SQL. This function can replace the character you specified. The following describes how to use the update statement.

Mysql replace string function can replace some strings of a field with other strings, for example

The Code is as follows:	Copy code
Update dede_addonarticle set body = replace (body, 'news/uploads/allimg/c110826', 'news/uploads/blank.gif? ')

You can replace all the image links in the dedecms article content table with blank images, so that you can delete a large number of uploaded images to save space.