You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2020-07-13' at line 3

select * from users
where email like '%gmail.com'
and created_at between '2020-07-12' and '2020-07-13'