2

I'm working on creating a online quiz program. I want to change questions every time new user logging in. Is there any way to get questions from database randomly?

I have tried rand() function but it generates same question again and again.

NoobTW
  • 2,466
  • 2
  • 24
  • 42
avishkaME
  • 114
  • 1
  • 2
  • 8

1 Answers1

0

You can use NEWID() of MySQL. The SQL SELECT NEWID() function returns the random row. GUID in memory for each row. By definition, the GUID is unique and random so, you will get the perfect random record.

Example:

SELECT * FROM Table ORDER BY NEWID()

TO know more you can click here

Ankur Tiwari
  • 2,762
  • 2
  • 23
  • 40