How to select data from MySql table by minimum date with additional condition?

Question

MySQL

Help to make a SQL query for a beginner. There is a table accounts consisting of three fields (login, status, date). The status field can have multiple values, such as "active" and "free"

I need to return the string with the smallest date and whose status will be free.

This is how it turns out to select only by the minimum date: Select * from `accounts` where date IN (SELECT MIN(`date`) FROM `accounts`)

This is how I tried to write an additional condition: Select * from `accounts` where date IN (SELECT MIN(`date`) FROM `accounts`) AND `status`= 'free'

I went to learn SQL, I will be very grateful for the help kind people)

Answer 1

So, well, I'm not a real DBA, but I see you have such an error:
you check the date field, and it can be like this: 2016-09-26 14:31:31
I would do this

select * from accounts where date(date) IN (select date(min(date)) from accounts) and status = 'free';