Page 1 of 1

Select record in a tabl randomly

Posted: Tue Jul 13, 2004 5:31 am
by kevin7
hmm...
i wanna to display a record which is randomly selected from a table...

what syntax allow me to do so?

tq...

Posted: Tue Jul 13, 2004 9:14 am
by kettle_drum

Code: Select all

SELECT blah FROM table ORDER BY RAND() LIMIT 1