mysql替换自符串
时间: 2023-08-25 18:18:57 浏览: 39
MySQL提供了replace()函数来替换字符串。你可以使用以下语法进行替换操作:
UPDATE `table_name` SET `field_name` = REPLACE(`field_name`, 'from_str', 'to_str') WHERE `field_name` LIKE '%from_str%'
这个语句将会在指定的表中,将字段中包含'from_str'的字符串替换成'to_str'。请注意,这个操作是针对满足指定条件的记录进行的。 [2]
另外,你也可以使用SELECT语句结合replace()函数来替换字符串。以下是一个示例:
SELECT bkName as '替换前', REPLACE(bkName, 'en', 'aa') AS '替换后' FROM books
这个语句会将查询结果中的bkName字段中的所有'en'替换为'aa'。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [mysql 替换字符串的实现方法](https://blog.csdn.net/chen7360/article/details/119931958)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [mysql替换字符串技巧](https://blog.csdn.net/qq1124794084/article/details/81775651)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [mysql 替换字符串](https://blog.csdn.net/xx_star1204/article/details/72934686)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]