Use of replace syntax for MySQL batch replacement

In practice, you need to replace the content of a field in a table in batches. The general thinking process is as follows: SELECT out str_replace replace UPDATE write the actual

In practice, you need to replace the content of a field in a table in batches. The general thinking process is as follows: SELECT out str_replace replace UPDATE write the actual

In practice, you need to replace the content of a field in a table in batches. The general thinking process is as follows:

SELECT

Replace str_replace

UPDATE write

In fact, this is a waste of resources and resource consumption. MYSQL has a built-in syntax for bulk replacement.

Replace it directly. You can also follow the WHERE condition statement later.

Multiple words can be replaced at the same time.

It's very powerful. The one-time replacement of multiple columns that are not available on the Internet is now recorded.