ランダムにレコードを選ぶ

db

参照：random関数 - SQLite関数の使い方 - SQLite入門

rand()で乱数生成。absで正の数に限定し、「% カラム数」で乱数の範囲を限定する。

/*原型はこれ*/
SELECT * FROM table WHERE pk_uid = abs(random()) % 10

SELECT * FROM yohoku WHERE pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359
or pk_uid = abs(random()) % 1359;