有没有办法在单个查找中强制MySQL/Rails区分大小写? [英] Is there a way to force case sensitivity in MySQL / Rails for a single find?

问题描述

我正在搜索标签，有些用户喜欢"cat"，而有些用户喜欢"Cat" Go Figure ...

I'm doing some searching of tags, and some users like "cat" while others like "Cat" Go figure...

无论如何，是否有一种方法可以使特定发现区分大小写?如:

Anyways, is there a way to force a particular find to be case sensitive? Such as:

Tag.find(:some-special-option-here)

有什么想法吗?

推荐答案

您还可以执行区分大小写的搜索，而无需更改列属性.

You can also do a case-sensitive search without changing your column properties.

SELECT * FROM mytable WHERE myfield='Value' 

此查询匹配:

• 值
• 值
• VALUE
• vALUe
• 等等

• Value
• value
• VALUE
• vAlUe
• and so on

而...

SELECT * FROM mytable WHERE BINARY myfield='Value'

仅匹配项:

• 值

这篇关于有没有办法在单个查找中强制MySQL/Rails区分大小写?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！