修改chatuser表中把所有姓小的用户改为姓李的操作如下:
数据库中随机查询
update chatuser set uname=CONCAT('李', SUBSTRING(uname,2)) WHERE uname like '小%';
数据库中随机查询
select * from tablename order by rand() limit 10