来自查询的随机项目

Question

I have a database with 16000 rows. I want to grab a random 400 rows.

How would I accomplish this task? Would I do it in Sql? Or select all 16000 rows and then dump a random 400 into an array?

I'm new to PHP and programming..

Thanks for any help.

$result = mysql_query ('SELECT * FROM AllImages') or die ('Error query: '.mysql_error ());

Answer 1

SELECT * FROM AllImages order by RAND() limit 400