SELECT
*
FROM
sign2023
表名
WHERE
game_id = 1616 /赛事id/
AND pack_id = 4679 /*组别id*/
AND is_lucky = 0
ORDER BY
RAND( )
LIMIT 10;
返回10条符合以上条件的记录
SELECT
*
FROM
sign2023
表名
WHERE
game_id = 1616 /赛事id/
AND pack_id = 4679 /*组别id*/
AND is_lucky = 0
ORDER BY
RAND( )
LIMIT 10;
返回10条符合以上条件的记录