卡密-随机取一条周卡卡密

SELECT * FROM `eruyi_kami2` WHERE `new` = 'y' and `type` = 'ZK' and id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `eruyi_kami2`))) LIMIT 1

只显示 kami 数据

SEL ECT kami FROM `eruyi_kami2` WHERE `new` = 'y' and `type` = 'ZK' and id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `eruyi_kami2`))) LIMIT 1