MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
With the COLLATE
clause, you can override
whatever the default collation is for a comparison.
COLLATE
may be used in various parts of SQL
statements. Here are some examples:
With
ORDER BY
:Press CTRL+C to copySELECT k FROM t1 ORDER BY k COLLATE latin1_german2_ci;
With
AS
:Press CTRL+C to copySELECT k COLLATE latin1_german2_ci AS k1 FROM t1 ORDER BY k1;
With
GROUP BY
:Press CTRL+C to copySELECT k FROM t1 GROUP BY k COLLATE latin1_german2_ci;
With aggregate functions:
Press CTRL+C to copySELECT MAX(k COLLATE latin1_german2_ci) FROM t1;
With
DISTINCT
:Press CTRL+C to copySELECT DISTINCT k COLLATE latin1_german2_ci FROM t1;
With
WHERE
:Press CTRL+C to copySELECT * FROM t1 WHERE _latin1 'Müller' COLLATE latin1_german2_ci = k;
Press CTRL+C to copySELECT * FROM t1 WHERE k LIKE _latin1 'Müller' COLLATE latin1_german2_ci;
With
HAVING
:Press CTRL+C to copySELECT k FROM t1 GROUP BY k HAVING k = _latin1 'Müller' COLLATE latin1_german2_ci;