SELECT {$field} FROM {$table} as t1 WHERE id IN ( SELECT t.id FROM (SELECT id FROM {$table} where 1=1 {$where} ORDER BY RAND() {$limit} ) AS t )
sql 随机查询数据
原文：http://www.cnblogs.com/chenzhaojx/p/3939047.html
