QAds
Sony Cybershot DSC-W220 12.1MP Digital Camera with 4x Optical Zoom
$104.99
Motorola RIZR Z8 Ferrari Quad-Band, 2 MP Camera, MP3 Player and MicroSD Slot
$194.99
Samsung SL30 10MP Digital Camera with 3x Optical Zoom and 2.5 inch LCD
$69.74
Apple iPod nano 8 GB Siyah
$88.21
:: HOME MySQL RAND function - Random Data
 
RAND function - Random Data

How to query random data row by MySQL:

SELECT * FROM table_name ORDER BY RAND() LIMIT 1;

To be able to get random row or rows from database you just need to use RAND() at ORDER BY and after that determine the how many rows you want to get by using LIMIT.