Page is a not externally linkable
- Code, Content, and Presentation
---- Using Rand to return 2 results
redhatlab - 9:56 pm on Aug 11, 2010 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4185452.htm
You can use DISTINCT or GROUP BY to avoid duplicate records. Also make sure you are joining the tables using proper index, because the day the tables are big the query is going to take longer.
Brought to you by WebmasterWorld: http://www.webmasterworld.com