思路:
首先写自己想要的查询的结果集
SELECT
a.id as id,
a.type as type,
a.content as content
FROM
autoadd as a
WHERE a.type = 1
随机 + 一条 也就是先打乱查询顺序再选一条
使用 ORDER BY RAND() LIMIT 0,1
完工:
SELECT
a.id as id,
a.type as type,
a.content as content
FROM
autoadd as a
WHERE a.type = 1 ORDER BY RAND() LIMIT 0,1