How to replace characters in mysql

Editor to share with you how to replace characters in mysql, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The way to replace characters in mysql: use update substitution, code is [UPDATE table name SET the field you want to replace = replace (the field you want to replace,',')].

The method of replacing characters in mysql:

1. There are many spaces in the data you are looking for. It would be very inconvenient to export the data. You only need to use one statement, update. For example, if you remove the spaces, you can write the UPDATE table name SET the field you want to replace = replace (the field you want to replace,',').

2. For example, if I want to replace the spaces in the title, I will write UPDATE car_articles SET article_title = replace (article_title,','). As a result, there will be no spaces.

3. If you want to replace one character in batch with another. For example, change the field with "Beijing" to Shanghai. Write UPDATE car_brands SET name = replace (name, 'Beijing', 'Shanghai')

The above is all the contents of how to replace characters in mysql. 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!