Tags
PHP , MySQL
Asked 3 years ago
14 Jul 2021
Views 646
Roy

Roy posted

How can I randomize database rows if i am using mysql objects

I want random record from the database rows , i am suing mysql objects . please give me suitable advise
jqueryLearner

jqueryLearner
answered Jul 17 '21 00:00

do it with Mysql itself in query by using RAND() function
use rand() in where clause

select * from student where RAND()


above query give randomize result every time you run or execute it
Post Answer