Hola, primero, asumo q el campo deliveryday es datetime, segundo te recomendaria que uses la funcion date_format
Asi:
Código PHP:
SELECT * FROM OPERATION WHERE DELIVERYDAY BETWEEN DATE_FORMAT('04/01/2006','%d/%m/&Y') and DATE_FORMAT('25/01/2006','%d/%m/&Y')