order by문 case문쓰기

$sort = "  CASE WHEN StartDate > date_format( now() , '%Y-%m-%d %h:%i:%S' ) 

THEN 2 

WHEN StartDate < date_format( now() , '%Y-%m-%d %h:%i:%S' ) 

AND EndDate >= date_format( now() , '%Y-%m-%d %h:%i:%S' )

THEN 1 

WHEN EndDate < date_format( now() , '%Y-%m-%d %h:%i:%S' ) 

THEN 3 

 end asc ,StartDate desc,Date desc ";

이것을 

select * from table order by $sort