RSS

Tag Archives: 文本替换

MySQL中使用REPLACE替换文本

UPDATE table_name
SET field_name = REPLACE(field_name, ‘old_string’, ‘new_string’)
WHERE your_field LIKE ‘%old_string%’


 
添加留言

Posted by on 八月 14, 2013 in solutions

 

Tags: , ,