SQL for more than one condition
public sql v1 · immutableselect * 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 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