Using If and else if in mysql query

I am getting mismatched count from db i think its may be a some duplicates

SELECT * FROM table_name WHERE (field_name1 ='xxx' AND (field_name2 ='' OR filed_name3 ='')) OR (field_name4 = 'yyy' AND (filed_name3 =''));