我想使用时间戳选择范围内的壁纸像这个
SELECT * FROM wallpaper WHERE timestamp = '1221507428' to '1221761585' ORDER BY RAND() LIMIT 5
如何固定时间使用时间戳?
使用between
,这里是完整的查询:
SELECT * FROM wallpaper WHERE `wallpaperid` between '1221507428' and '1221761585' ORDER BY RAND() LIMIT 5
更多信息
使用BETWEEN。。。AND构造。
SELECT *
FROM wallpaper
WHERE `timestamp` BETWEEN '1221507428' AND '1221761585'
ORDER BY Rand()
LIMIT 5
也可以使用比较运算符
SELECT *
FROM wallpaper
WHERE `timestamp` >= '1221507428'
OR `timestamp` <= '1221761585'
ORDER BY Rand()
LIMIT 5