charset-collate.md

### 10.8.1 在 SQL 语句中使用 COLLATE

随着`整理`子句，您可以覆盖任何默认排序规则进行比较。`整理`可用于 SQL 语句的各个部分。这里有些例子：

-   和`订购方式`：

    ```
    SELECT k
    FROM t1
    ORDER BY k COLLATE latin1_german2_ci;
    ```

-   和`作为`：

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

-   和`通过...分组`：

    ```
    SELECT k
    FROM t1
    GROUP BY k COLLATE latin1_german2_ci;
    ```

-   使用聚合函数：

    ```
    SELECT MAX(k COLLATE latin1_german2_ci)
    FROM t1;
    ```

-   和`清楚的`：

    ```
    SELECT DISTINCT k COLLATE latin1_german2_ci
    FROM t1;
    ```

-   和`在哪里`：

    ```
         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;
    ```

-   和`拥有`：

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