电话号码表t_phonebook中含有100万条数据,其中号码字段PhoneNo上创建了唯一索引,且电话号码全部由数字组成,要统计号码头为321的电话号码的数量,下面写法执行速度最慢的是___
select count(*) from t_phonebook where phoneno >= ‘321’ and phoneno < ‘321A’
select count(*) from t_phonebook where phoneno like ‘321%’
select count(*) from t_phonebook where substr(phoneno,1,3) = ‘321’
都一样快