mysql rand() 大写,MySQL查询-使用ORDER BY rand（）强制区分大小写

Is it possible to force case-sensitive for a query?

Mine sounds like this:

"SELECT g_path FROM glyphs WHERE g_glyph = :g_glyph ORDER BY rand()"

if g_glyph = r, the result can be R or r and it's not what I expect.

I'm looking for a case-sensitive return.

I googled my issue and I found this solution:

/*Case-sensitive sort in descending order.

In this query, ProductName is sorted in

case-sensitive descending order.

*/

SELECT ProductID, ProductName, UnitsInStock

FROM products

ORDER BY BINARY ProductName DESC;

But the following line doesn't work at all:

"SELECT g_path FROM glyphs WHERE g_glyph = :g_glyph ORDER BY BINARY rand()"

Any Suggestion?

Thank you very much for your help.

解决方案

The order and equality of characters is defined by the collation. In most cases, a case-insensitive collation is used.

If you need to use a strict, case-sensitive comparison for a specific datum, use the BINARY operator:

mysql> SELECT 'a' = 'A';

-> 1

mysql> SELECT BINARY 'a' = 'A';

-> 0

mysql> SELECT 'a' = 'a ';

-> 1

mysql> SELECT BINARY 'a' = 'a ';

-> 0

So in your case:

SELECT g_path FROM glyphs WHERE BINARY g_glyph = :g_glyph ORDER BY rand()