SQL syntax in QUICK

I use phpMyAdmin to check my systax, it can work. whether they are different from phpMyAdmin and vData?

I use OUICK to search data, and I got error message as below:

---

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 'WHERE Key_name IN('PRIMARY', 'Unique')' at line 6

---

I use this syntax

SELECT *
FROM `tablename`
WHERE `fieldname`
BETWEEN '2018-01-01 00:00:00'
AND '2018-01-31 00:00:00'

Could you tell me how can I do?