Quick question, how do i run a query in MySQL so i can display items that are between two dates?
for example, todays date, and 7 days later?
I saw something similar to this however it wont allow it to run as it comes up with an error.
Code: Select all
SELECT * FROM t1
-> WHERE (t1.soon > 'CURRENT_DATE');Any help is much appreciated, Cheers