sql模糊查询

create table test
(
    name varchar(20)



)

select name from test where name like 'aa%';
select name from test where name like 'aa%' and name <> 'aab';

在geohash中用于查找。