您的位置:首页 > 博客中心 > 数据库 >

sql 随机查询数据

时间:2022-03-13 23:02

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 )

  

热门排行

今日推荐

热门手游