select * from abc like '1%' ???你根本就没有写在哪个列里查呀，肯定列名无效咯。select * from abc where xxx like '1%'
正确的应该是：select * from [表名] where [字段] like '1%'
数据库模糊查询
