SELECT *
FROM car_appointment
WHERE date_format( app_time, '%m%d' )
BETWEEN
FROM car_appointment
WHERE date_format( app_time, '%m%d' )
BETWEEN
date_format( now( ) , '%m%d' )
AND date_format( date_add( now( ) , INTERVAL 3 DAY ) , '%m%d' )
AND date_format( date_add( now( ) , INTERVAL 3 DAY ) , '%m%d' )