All Products
Search
Document Center

Collation operators

Last Updated: Jun 18, 2021

The following table lists all collation operators.

Operator

Operand

Description

COLLATE

Unary (suffix)

The collation.

Examples

SELECT last_name
  FROM employees
 ORDER BY last_name COLLATE UTF8MB4_GENERAL_CI;