How can I extract data from a MySQL database in random order?

Question

I have a tabel named "intrebari" with fields "id" and "intrebare". How can I extract that in a table, but in random order?

can you give me an example? – dpaul1994 Jul 17 '14 at 11:32 — dpaul1994, Jul 17 '14 at 11:32
and that's all? it will extract in random order? – dpaul1994 Jul 17 '14 at 11:33 — dpaul1994, Jul 17 '14 at 11:33

score 1 · Answer 1 · answered Jul 17 '14 at 11:36

If you want to select the entire contents of the table:

SELECT * FROM `intrebari` ORDER BY RAND()

If however you only want a small subset of a large table, it may be more efficient to generate 5 random numbers in the range with php and use WHERE IN instead

Kaushik Maheta · Answer 2 · 2014-07-17T11:42:58.660

1

Use rand() function

SELECT * FROM table ORDER BY RAND();

edited Jul 17 '14 at 11:42

answered Jul 17 '14 at 11:36

Kaushik Maheta

1,741
1
18
27

score 0 · Answer 3 · answered Jul 17 '14 at 11:32

0

Try this: use rand

SELECT * FROM `intrebari`
ORDER BY RAND()

answered Jul 17 '14 at 11:32

Awlad Liton

9,366
2
27
53

score 0 · Answer 4 · answered Jul 17 '14 at 11:33

0

If you are asking about getting random result from the table randomly then you can try the following:

SELECT * FROM tbl_name ORDER BY RAND();

Hope this helps.

answered Jul 17 '14 at 11:33

Techroshni

541
2
11

If this was useful, please mark it as Useful..Thanks – Techroshni Jul 17 '14 at 11:39

score 0 · Accepted Answer · answered Jul 17 '14 at 11:36

0

If you don't want to extract all records, and want to sort the randomly retrieved records, use,

SELECT * FROM (SELECT * FROM users ORDER BY rand() LIMIT 10) Tb ORDER BY id

answered Jul 17 '14 at 11:36

sadiq.ali

526
1
6
16

Tb is just a table alias. Like we use in, select a.id, a.name from long_table_name a; – sadiq.ali Jul 17 '14 at 12:30

How can I extract data from a MySQL database in random order?

5 Answers5