Home >Database >Mysql Tutorial >mysql查询区分大小写的问题_MySQL
mysql查询区分大小写的问题_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:42:151163browse
bitsCN.com
mysql查询区分大小写的问题 mysql查询默认是不区分大小写的 如：
select * from table_name where a like 'a%'
select * from table_name where a like 'A%'
效果是一样的。
要让mysql查询区分大小写，可以：
select * from table_name where binary a like 'a%'
select * from table_name where binary a like 'A%' 也可以在建表时，加以标识
create table table_name( a varchar(20) binary ) 作者 sss0213 bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL数据库表损坏解决办法_MySQLNext article：MySQL在Centos的卸载和安装_MySQL