Why is my query not working using the BETWEEN operator?

Question

I am trying to run a query and get a result based on 2 dates. When using the query below I keep getting this error.

You have an error in your SQL syntax; check the manual that corresponds to the right syntax to use near 'BETWEEN '2017-12-10' AND '2017-12-30')' at line 1

Below is the query I am trying to use. I am not sure what I am doing wrong here.

Any help would be really appreciated!

SELECT * FROM checkout WHERE id = 10 AND (BETWEEN '2017-12-10' AND '2017-12-30')

possible duplicate of https://stackoverflow.com/questions/3822648/how-do-i-query-between-two-dates-using-mysql — Sanjit Bhardwaj, Jan 27 '18 at 06:07

score 1 · Answer 1 · answered Jan 27 '18 at 06:08

1

You are not providing the column name for between

column_name BETWEEN value1 AND value2

https://www.w3schools.com/sql/sql_between.asp

answered Jan 27 '18 at 06:08

Ajay Singh Deopa

136
1
4

score 1 · Answer 2 · answered Jan 27 '18 at 06:08

1

Add a column name before "between"

SELECT * FROM checkout WHERE id = 10 AND ( `columnname` BETWEEN '2017-12-10' AND '2017-12-30')

This will help you

answered Jan 27 '18 at 06:08

Lalit Mohan

464
3
16

Why is my query not working using the BETWEEN operator?

2 Answers2