MySQL:SELECT 语句是否区分大小写?

MySQL: is a SELECT statement case sensitive?(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.

这篇关于MySQL:SELECT 语句是否区分大小写?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！