Question

SQL语句如何查询首字母大写？

比如名字名字是英文把首字母大写的名字都查询出来，语句怎么血？

Answer 1

select * from 表 where 字段 collate chinese_prc_cs_as_ws like 'A%' (查大写 )
select * from 表 where 字段 collate chinese_prc_cs_as_ws like 'a%' (查小写 )
--就是在字段名后加 collate chinese_prc_cs_as_ws

Answer 2

SELECT * FROM tablename WHERE (ASCII(SUBSTRING(fieldname, 1, 1)) > 64) AND (ASCII(SUBSTRING(fieldname, 1, 1)) < 91)

Answer 3

where substring(field,1,1) between 'A" and 'Z'