常用语句
- 批量修改某个字段，并在该字段前面拼接一个字符串
bash
SELECT CONCAT('custom/', field) FROM `user_table` where name LIKE 'dev%'
update user_table set field = CONCAT('custom/', field) where name LIKE 'dev%'