How to make a selection from MYSQL by interval?

Question

MySQL

Prompt how to make selection from a DB on an interval.
For example, select all records on the first day of each month at 00 hours 00 minutes 00 seconds

Answer 1

The easiest way is to use the LIKE operator:

select * from test where created_at like '%-01 00:00:00';

SQL fiddle