SELECT多行WHERe匹配两个条件

SELECT多行WHERe匹配两个条件

尝试，

SELECt userIDFROM tableNameWHERe   (questionID = 14 AND        answer = 'yes' ) OR        (questionID = 54 AND        answer <> 'empty') OR        (questionid = 100 AND        answer > 10)GROUP BY userIDHAVINg COUNT(*) = 3

SQLFiddle演示