I am developing a mobile application that has thousands of records in a table and has a word of the day feature. The problem is that sqlite does not support seeding random function like mysql does in this sample query
SELECT *
FROM word_table
ORDER BY RAND('. date("mdY") .') LIMIT 1
Is there any other way that I can just query 1 item per day without inserting date to each item as it is time consuming?
Thanks Guys
Aucun commentaire:
Enregistrer un commentaire