select * from article where (
  IF(author like 'Bob', 1, 0) +
  IF(journal like 'MyJournal', 1, 0) +
  IF(sciencefield = 'science', 1, 0) +
  IF(department like 'Mathematics', 1, 0)
) >= 2