随机取n条记录
SELECT * FROM table order by rand() limit n
注意的是,limit不能出现在子查询中。
可以这么进行修改:
加一层嵌套
SELECT * FROM (SELECT * from tablename order by rand() limit 5) as t
随机取n条记录
SELECT * FROM table order by rand() limit n
注意的是,limit不能出现在子查询中。
可以这么进行修改:
加一层嵌套
SELECT * FROM (SELECT * from tablename order by rand() limit 5) as t