使用该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;