TalkPHP - View Single Post - How to get random number based on the condition.

Village Idiot · 03-29-2010, 07:12 PM

Here is one way that comes to mind (adapt the select statement to your needs:

SQL Code:

SELECT *, RAND() AS orderByMe FROM tableName WHERE 1 ORDER BY orderByMe LIMIT 1

03-29-2010, 07:12 PM	#2 (permalink)
Village Idiot Wizard Join Date: Sep 2007 Posts: 1,299 Thanks: 17	Here is one way that comes to mind (adapt the select statement to your needs: SQL Code: SELECT *, RAND() AS orderByMe FROM tableName WHERE 1 ORDER BY orderByMe LIMIT 1 __________________