Shulou(Shulou.com)06/01 Report--

This article mainly shows you "how to batch search to replace the content in the MySQL database", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to batch search to replace the content in the MySQL database" this article.

Batch search replaces content in MySQL database

The statement is as follows:

UPDATE table SET field = replace (field, text_needs_to_be_replaced, text_required)

For example, if I want to replace all John with the following Mark

UPDATE student SET student_name = replace (student_name, 'John',' Mark')

The statement is issued as follows

The above substitution is used to search and replace all student_name. If you need to limit specific data, you can add where qualification later, as follows:

UPDATE student SET student_name = replace (student_name, 'John',' Mark') where id = 11; the above is all the contents of the article "how to search in bulk to replace the content in the MySQL database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.