All Products
Search
Document Center

COLLATE operator

Last Updated: Dec 31, 2019

The following table lists all collation operators.

Operator Operand Description
COLLATE Unary (suffix) The collation to be used

Example:

  1. SELECT last_name
  2. FROM employees
  3. ORDER BY last_name COLLATE UTF8MB4_GENERAL_CI;