select * from tablename where 1=1 ${if(fine_username="101567" ,"","and a2='"+LEFT($fine_display_name,FIND("(",$fine_display_name) - 1)+"'")},想要实现除101567这个工号能看到所有的,100339这个工号的也可以,应该怎么写
select * from tablename
where 1=1
${if(fine_username="101567"||fine_username="100339","","and a2='"+LEFT($fine_display_name,FIND("(",$fine_display_name) - 1)+"'")}
select * from tablename where 1=1 ${if(or(fine_username="101567",fine_username="100339") ,"","and a2='"+LEFT($fine_display_name,FIND("(",$fine_display_name) - 1)+"'")}