MySQL:SELECT 语句是否区分大小写?
谁能告诉我 MySQL SELECT 查询默认是区分大小写还是不区分大小写?如果没有，我必须发送什么查询才能执行以下操作:
Can anyone tell me if a MySQL SELECT query is case sensitive or case insensitive by default? And if not, what query would I have to send so that I can do something like:
SELECT * FROM `table` WHERE `Value` = "iaresavage"
实际上，Value的真正价值是IAreSavage.
Where in actuality, the real value of Value is IAreSavage.
推荐答案
它们不区分大小写，除非你做一个 二进制比较.
They are case insensitive, unless you do a binary comparison.
相关文章