mysql程序 - 从五个数字中随机数

Question

我有 5 个带数字的 INT 变量。我想从 mysql 过程中的五个变量中选择一个随机数。

示例数据:

DECLARE a, b, c, d, e INT;
SET a = 50;
SET B = 22;
SET C = 88;
SET D = 892;
SET E = 367;

现在我想从变量a、b、c、d、e中选择一个随机数。任何想法如何去做？谢谢。

Answer 1

SELECT * FROM MyTable ORDER BY RAND() LIMIT 1

更新

SELECT * FROM

(

SELECT @A AS Val

UNION ALL

SELECT @B AS Val

UNION ALL

SELECT @C AS Val

UNION ALL

SELECT @D AS Val

UNION ALL

SELECT @E AS Val

) F

ORDER BY RAND() LIMIT 1