array_shuffle

SinceVersion 2.0

array_shuffle shuffle

description

Syntax

  1. ARRAY<T> array_shuffle(ARRAY<T> array1, [INT seed])
  2. ARRAY<T> shuffle(ARRAY<T> array1, [INT seed])

将数组中元素进行随机排列。其中，参数array1为要进行随机排列的数组，可选参数seed是设定伪随机数生成器用于生成伪随机数的初始数值。 shuffle与array_shuffle功能相同。

  1. array_shuffle(array1);
  2. array_shuffle(array1, 0);
  3. shuffle(array1);
  4. shuffle(array1, 0);

example

  2. mysql [test]> select c_array1, array_shuffle(c_array1) from array_test; 
  3. +-----------------------+---------------------------+
  4. | c_array1              | array_shuffle(`c_array1`) |
  5. +-----------------------+---------------------------+
  6. | [1, 2, 3, 4, 5, NULL] | [2, NULL, 5, 3, 4, 1]     |
  7. | [6, 7, 8, NULL]       | [7, NULL, 8, 6]           |
  8. | [1, NULL]             | [1, NULL]                 |
  9. | NULL                  | NULL                      |
  10. +-----------------------+---------------------------+
  11. 4 rows in set (0.01 sec)
  13. MySQL [test]> select c_array1, array_shuffle(c_array1, 0) from array_test; 
  14. +-----------------------+------------------------------+
  15. | c_array1              | array_shuffle(`c_array1`, 0) |
  16. +-----------------------+------------------------------+
  17. | [1, 2, 3, 4, 5, NULL] | [1, 3, 2, NULL, 4, 5]        |
  18. | [6, 7, 8, NULL]       | [6, 8, 7, NULL]              |
  19. | [1, NULL]             | [1, NULL]                    |
  20. | NULL                  | NULL                         |
  21. +-----------------------+------------------------------+
  22. 4 rows in set (0.01 sec)

keywords

ARRAY,ARRAY_SHUFFLE,SHUFFLE