Random SQL Results
// November 12th, 2008 // Database, MySQL, PHP, SQL
Last year I needed to display 3 random featured items. The solution was very simple using MySQL with this query:
SELECT * FROM `table` WHERE `column` = 'criteria' ORDER BY RAND() LIMIT 3;
