Arrange by date data from MySQL db

I am using field "date" type "datetime" in format YYYY-MM-DD HH:MM:SS in MySQL db.
My fields contains date, name, description.
I want to create a dropdown menu that can query db and show field with Today, Yesterday, last month, all time.
I also need to put a form having Fields FROM: dd/mm/yy TO : dd/mm/yy that can display all fields ranging between To and From values.

I will be really thankful for any help in logic or code.

Note: All this thing will be displayed on password protected page accessible only to admin.