MySQL 查詢技巧 ─ 查詢 N 天內記錄、隨機查詢記錄 查詢 N 天內記錄 Select book_id,book_name,book_desc From book_main Where book_status = 1 And book_add_date > Date_Sub(Now(),Interval 7 Day) Order By Rand() 隨機查詢一筆記錄 Select book_id,book_name,book_desc From book_main Where book_status = 1 Order By Rand() Limit 0,1