Basic

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.

Found a mistake? Have a question or improvement idea? Let me know.

ORDER BY:

*Basic

*ASCending DESCending

Table Of Contents

0Getting started with MySQL

1Limit and Offset

2Creating Databases

3Backup using mysqldump

4Table Creation

7Stored routines, procedures and functions

8Reserved Words

9String operations

12Indexes and Keys

13Date and Time Operations

15LOAD DATA INFILE

16PREPARE Statements

20Change Password

24Pivot Queries

25Configuration and tuning

26Converting from MyISAM to InnoDB

28Create New User

33Performance Tuning

36Install MySQL with Docker

38Character Sets and Collations

39MyISAM Engine

40Many-to-many Mapping table

41Using Variables

44Security via GRANTs

47MySQL LOCK TABLE

49ORDER BY

51MySQL Performance Tips

52Temporary Tables

54Customize PS1

55Dealing with sparse or missing data

56Dynamic Un-Pivot Table using Prepared Statement

59Connecting with UTF-8

60SSL Connection Setup

61Handling Time Zones

62Time with subsecond precision

63Error 1055 ONLY FULL GROUP BY

64Full-Text search

65Extract values from JSON type

66Regular Expressions

67Recover and reset default root password

69JOINS Join 3 tables

70Server Information

71Recover from lost root password