mysql - sql query to get data between two dates -

mysql - sql query to get data between two dates -

this question exact duplicate of:

search info sql between 2 dates 1 reply

**how info between 2 dated?

i search between 2 dates in 1 month illustration between 02-02-2013 , 09-02-2013 result showing 03-01-2013 08-01-2013 , 03-02-2013 08-02-2013 date format in database ss-mm-yyyy hh:mm:ss please help**

try:

select id,job_name,details,type,dw_no,rem_no,user,date tracker date between '02-02-2013' , '08-02-2013' order id desc;

but don't know mean steatment 1=1 ?

mysql