How to replace characters in mysql

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

##More related free learning recommendations: mysql tutorial(Video)

How to replace characters in mysql:

1. There are many spaces in the searched data. It will be particularly inconvenient if you export the data. Just use a single update statement. For example, if you remove the spaces, you can write it as

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 write UPDATE car_articles SET article_title = replace(article_title, ' ', ''). The result is as follows, there will be no spaces. .

#3. If you want to replace a certain character with another one in batches. For example, change the field with "Beijing" to Shanghai. Just write UPDATE car_brands SET name = replace(name, 'Beijing', 'Shanghai')

The above is the detailed content of How to replace characters in mysql. For more information, please follow other related articles on the PHP Chinese website!