MySQL batch replacement of the specified field string SQL statement and instance Analysis _ MySQL

MySQL batch replaces the specified field string SQL statement and instance analysis bitsCN. comMySQL batch replacement is a feature that we often use. sometimes, when the site contains sensitive words, it will cause us trouble. However, when the amount of information is large, it is unrealistic to search and modify an article.
It is easy to use MySQL for batch replacement. Released here for reference.
MySQL batch replace a specified field string statement
UPDATE data table name SET field name = replace (field name, string to be replaced, replace with) WHERE to SET conditions;
For example, the website found that the title of the article about linux commands on the site is not very good today. in the past, we used to explain how to use mkdir commands in linux --- create directory commands in linux
This format is not very useful for searching because few people search for mkdir in details and mkdir in linux, and then search for mkdir commands, mkdir parameters,
Mkdir, usage, and linux mkdir (with spaces instead of a "lower" character in the middle) are widely used. for a comprehensive consideration, the mkdir command parameters and usage are changed to linux. --- create a directory command in linux
Obviously, this kind of keyword containing more is more in line with users' search habits. If you change it, you can change it. However, the current website has issued several hundred commands, and manual modification will be exhausting.
As a result, you can run a few commands on mysql.
UPDATE 'so so _ archives 'set 'title' = replace (title, linux) WHERE 'typeid' = 18;
UPDATE 'so so _ archives 'set 'title' = replace (title, command usage details, command parameters and usage details) WHERE 'typeid' = 18
You can set replacement conditions based on your needs. I hope you can collect this useful item for your convenience. BitsCN.com