In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-21 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
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!
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.