Skip to main content
Version: Latest-4.0

array_sort

Sorts the elements of an array in ascending order.

Syntax​

array_sort(array)

Parameters​

array: the array whose elements you want to sort. Only the ARRAY data type is supported.

Return value​

Returns an array.

Usage notes​

  • This function sorts the elements of an array only in ascending order.

  • NULL values are placed at the beginning of the array that is returned.

  • If you want to sort the elements of an array in descending order, use the reverse function.

  • The elements of the returned array have the same data type as the elements of the input array.

Examples​

The following table is used as an example:

mysql> select * from test;

+------+--------------+

| c1   | c2           |

+------+--------------+

|    1 | [4,3,null,1] |

|    2 | NULL         |

|    3 | [null]       |

|    4 | [8,5,1,4]    |

+------+--------------+

Sort the values of column c2 in ascending order.

mysql> select c1, array_sort(c2) from test;

+------+------------------+

| c1   | array_sort(`c2`) |

+------+------------------+

|    1 | [null,1,3,4]     |

|    2 | NULL             |

|    3 | [null]           |

|    4 | [1,4,5,8]        |

+------+------------------+