Avatar 👨‍💻

Daniel Zhang

Independent Developer | Full-Stack Engineer

  1. Home
  2. Products
  3. Blog
  4. Archives
  5. Search
  6. About Me
    1. Dark Mode
技术

MySQL 替换字段中某几个字符并更新

Jul 14, 2025 1 minute read

mysql 替换字段中某几个字符并更新

UPDATE `database`.`table` 
SET `column` = REPLACE(column,'旧字符串','新字符串');
MySQL
CC BY-NC-ND 4.0

Related content

使用MySQL时如何精准查询慢SQL

MySQL存储过程与Laravel中使用方式

MySQL导出和导入记录

MySQL 查询分表方法 【满足5.6.27版本】

ALTER TABLE ... LOCK ... 的使用

© 2026 Daniel Zhang
Built with Hugo
Theme Stack designed by Jimmy