hmm...
i wanna to display a record which is randomly selected from a table...
what syntax allow me to do so?
tq...
Select record in a tabl randomly
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
Code: Select all
SELECT blah FROM table ORDER BY RAND() LIMIT 1