Math
MySQL
RAND
MySQLMenghasilkan angka acak antara 0 (inklusif) dan 1 (eksklusif). Seed opsional untuk reproducibility.
Tipe hasil:
DOUBLEDiperbarui: 7 Jan 2026Syntax
SQL
RAND([seed])Parameter
seedintegeropsional
Seed untuk angka acak yang reproducible (opsional)
Contoh Penggunaan
Angka Acak
SQL
1 SELECT RAND() AS random1, RAND() AS random2;
Dua angka acak berbeda.
Hasil
random1: 0.xxx, random2: 0.yyy
Shuffle/Random Order
SQL
1 SELECT * FROM products 2 ORDER BY RAND() 3 LIMIT 5;
Mengambil 5 produk acak.
Hasil
(5 random products)
Random Integer
SQL
1 SELECT FLOOR(RAND() * 100) + 1 AS dice_1_to_100;
Angka acak 1-100.
Hasil
dice_1_to_100: (random 1-100)
