mysql statement not return correct result

Question

I have a mysql row with 'date = 2013-05-02, type = 1' etc.

Then I run this query

SELECT date, type, status, rate 
FROM reservation 
WHERE  type = 1 
AND date BETWEEN 2013-05-01 AND 2013-05-08  
ORDER BY date asc 
LIMIT 0, 10

But this returns empty results. What is the query issue here?

you should add single quotes around your dates and to get specific answer please give some sample data. — Ankur Trapasiya
– Ankur Trapasiya, Commented May 19, 2013 at 17:08
The most important thing to note here, just so you understand why it wasn't working, is because you were literally searching between (2013 minus 05 minus 01) and (2013 minus 05 minus 08), the quotes transform your data into a string that can be transformed into a date object — Bryan
– Bryan, Commented May 19, 2013 at 17:12
Nice explain Bryan. I never think of that. Many many thanks for you. ' Here after I'll change my view as you explained. Thanks again.. — Namal
– Namal, Commented May 19, 2013 at 17:16

ypercubeᵀᴹ · Accepted Answer · 2013-05-19 17:27:31Z

2

Put the dates in quotes ' in the mysql query.

SELECT date, type, status, rate 
FROM reservation 
WHERE  type = 1 
AND date BETWEEN '2013-05-01' AND '2013-05-08'
ORDER BY date ASC
LIMIT 0, 10 ;

ypercubeᵀᴹ

116k19 gold badges181 silver badges249 bronze badges

answered May 19, 2013 at 17:08

draxxxeus

1,5231 gold badge11 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shadrus · Accepted Answer · 2013-05-19 17:12:42Z

0

Try BETWEEN '2013-05-01' AND '2013-05-08'

answered May 19, 2013 at 17:12

shadrus

111 bronze badge

Did you not see that this has already been submitted as an answer?