How to get 10 videos from last 100 videos randomly?

[apollo2020]

I have a database indexing videos. I want to collect 10 videos randomly but only from the last 100 videos recently added. What's the sql string I should use for this?

 

MySql fields are:

$videoid

$date_added

 

// For example, ? is what I need unless the select statement is also altered

mysql_query("SELECT * FROM videos WHERE ? ");

[khr2003]

try this

mysql_query("SELECT * FROM videos rand() ASC LIMIT 0,100 ");

[fenway]

You'll need to use ORDER BY and LIMIT 100, and then run that in a sub-select for RAND().