mysql的if~else的用法

Question

select a.* from details as a,material as b 
WHERE a.number=b.number and direction='0' and material_name='轮胎' and
if( b.location_strategy=1,ORDER BY a.create_time,ORDER BY a.create_time DESC); 

这个实现方法是错误的，应该怎么改才能够使if~else语句正确执行，并且实现想要表达的逻辑

Answer 1

多了个AND吧