替换表里面特定数字

admin

1. UPDATE my_information
   
2. SET begintime = REPLACE(CAST(begintime AS CHAR), '1540', '1723')
   
3. WHERE CAST(begintime AS CHAR) LIKE '%1540%';

复制代码