ORDER BY x
x
can be any datatype.
NULLs
precede non-NULLs.
The default is
ASC
(lowest to highest)
Strings (
VARCHAR
, etc) are ordered according the
COLLATION
of the declaration
ENUMs
are ordered by the declaration order of its strings.