mysql查询以字符串开头的数据可以有:
1、select * from a where a.name like 'H%'
2、select * from a where left(a.name, 1)='H';
mysql查询不以某个字符串开头:
select * from a where left(a.name, 1)<>'H';
mysql查询以字符串开头的数据可以有:
1、select * from a where a.name like 'H%'
2、select * from a where left(a.name, 1)='H';
mysql查询不以某个字符串开头:
select * from a where left(a.name, 1)<>'H';