Laravel随机查询

//laravel
User::query()->whereIn('id', User::query()->select('id')->orderByRaw('rand() LIMIT :nums', 3)->get())->get()
//mysql
SELECT * FROM video WHERE id IN (SELECT id FROM (SELECT id FROM video ORDER BY rand() LIMIT 3) t)

posted @ 2021-12-03 10:03  可爱香草  阅读(13)  评论(0)    收藏  举报  来源