col_name COLLATE xxx_general_cs LIKE 'a%'
col_name LIKE 'a%' COLLATE xxx_general_cs
col_name COLLATE xxx_bin LIKE 'a%'
col_name LIKE 'a%' COLLATE xxx_bin
使用a搜索,以a或A开头的记录都将返回
col_name COLLATE xxx_general_cs LIKE 'a%'
col_name LIKE 'a%' COLLATE xxx_general_cs
col_name COLLATE xxx_bin LIKE 'a%'
col_name LIKE 'a%' COLLATE xxx_bin
使用a搜索,以a或A开头的记录都将返回