SQL查询排除特定ID的随机数据：使用NOT IN语句

///'使用子查询和NOT IN语句来添加条件，如下所示：//n//nSELECT * FROM txtnovellist AS t1 //nJOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM txtnovellist)) AS id) AS t2 //nWHERE t1.id >= t2.id AND t1.id NOT IN (1, 2, 3, 4) //nORDER BY t1.id //nLIMIT 10;///