update table_name set column_name = concat(substring_index(column_name,'@',1),'@120.199.9.25');
知识点扩展:
(1) concat函数合并字符串
(2) MySQL 字符串截取函数:left(str, length);right(str, length);substring(str, pos),substring(str, pos, len);substring_index(str,delim,count)[delim为分隔符;count为出现次数]
知识点扩展:
(1) concat函数合并字符串
(2) MySQL 字符串截取函数:left(str, length);right(str, length);substring(str, pos),substring(str, pos, len);substring_index(str,delim,count)[delim为分隔符;count为出现次数]