MySQL :: MySQL 8.3 Reference Manual :: 12.8.1 Using COLLATE in SQL Statements

version 8.3

8.0 current
5.7

8.0 Japanese

MySQL 8.3 Reference Manual / ... / Using COLLATE in SQL Statements

使用 COLLATE 子句，可以覆盖比较操作的默认排序规则。COLLATE 可以在 SQL 语句的多个部分使用。以下是一些示例：

与 ORDER BY：

SELECT k
FROM t1
ORDER BY k COLLATE latin1_german2_ci;

与 AS：

SELECT k COLLATE latin1_german2_ci AS k1
FROM t1
ORDER BY k1;

与 GROUP BY：

SELECT k
FROM t1
GROUP BY k COLLATE latin1_german2_ci;

与聚合函数：

SELECT MAX(k COLLATE latin1_german2_ci)
FROM t1;

与 DISTINCT：

SELECT DISTINCT k COLLATE latin1_german2_ci
FROM t1;

与 WHERE：

SELECT *
FROM t1
WHERE _latin1 'Müller' COLLATE latin1_german2_ci = k;

SELECT *
FROM t1
WHERE k LIKE _latin1 'Müller' COLLATE latin1_german2_ci;

与 HAVING：

SELECT k
FROM t1
GROUP BY k
HAVING k = _latin1 'Müller' COLLATE latin1_german2_ci;

PREV HOME UP NEXT