How to select an entry that starts with a specific date?

Question

MySQL

For example, there is a table:
journal_id | date |
213 | 09/05/2020
213 | 08/06/2020
333 | 01/01/2021
333 | 01/01/2021

And you need to output a log in which the earliest date starts from 01/01/2021. (very first entry)

Answer 1

SELECT * FROM table_name WHERE DATE(date) >= DATE(2021-01-01);

Try like this