Question

mysql如何随机取出几条记录，带where的

mysql如何随机取出几条记录，带where的

Answer 1

select * from student where name="张三" order by rand() limit 3; --随机提取3条数据

Answer 2

记录数多不多？ 不多用
SELECT * FROM 表 where 1=1 ORDER BY rand() LIMIT 10;