mysql - "if"查询mysql

Question

我想创建查询。

select member.name,depratment.name from member 
left join depratment on depratment.dep_id=member.dep_id
if(member.position_id=1){
 where member.ages>50; 
}
else{
where member.salary>50000;
}

帮帮我？谢谢。

Answer 1

我认为你不需要IF。你只需要一个复合条件。试试看，

SELECT..
FROM..
WHERE (member.position_id =  1 AND member.ages   > 50   ) OR
      (member.position_id <> 1 AND member.salary > 50000)