DaveKin

CREATE FUNCTION JSON_UNIQ(arr JSON) RETURNS json
BEGIN

	SET @arr = arr;
	SET @a_length = JSON_LENGTH(@arr);
	SET @loop_index = @a_length;

	WHILE @loop_index >= 0 DO

		SET @item = JSON_UNQUOTE(JSON_EXTRACT(@arr, concat('$[',@loop_index,']')));