select count(1) from users where name like '张%' 统计users表中姓张的人数

select count(*),substring(name,1,1) from info group by substring(name,1,1)