如何在MySQL表中查找所有大写字符串? [英] How to find all upper case strings in a MySQL table?

问题描述

我最初认为这是微不足道的.然后认为二进制"可能会做到这一点.我现在不确定.

I initially thought this is trivial. Then thought 'binary' might do it. I am unsure at this point.

Name
----
John
MARY
Kin
TED

我只想查询全部为大写的MARY和TED.我将如何查询?

I would like to query just MARY and TED which are in all upper case. How would I query this?

推荐答案

如果排序规则不区分大小写，则需要使用BINARY比较:

If your collation is case insensitive then you need to use a BINARY comparison:

SELECT *
FROM yourtable
WHERE Name = BINARY UPPER(Name)

查看其在线运行情况: sqlfiddle

See it working online: sqlfiddle

这篇关于如何在MySQL表中查找所有大写字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！