mysql - 你如何做一个 mysql WHERE something = 'something' OR ... (PHP)

Question

是否可以像这样进行 OR 语句？

WHERE pR.projectRelationId = '$id[ 0 ]' OR '$id[ 1 ]' OR '$id[ 2 ]'
AND pR.type = 'yada' AND

还是必须不断重新声明比较:

        WHERE 
            pR.projectRelationId = '$id[ 0 ]' OR 
            pR.projectRelationId = '$id[ 1 ]' OR 
            pR.projectRelationId = '$id[ 2 ]'
            AND
            pR.type = 'yada' AND

Answer 1

使用 IN:

pR.projectRelationId IN ('$id[ 0 ]', '$id[ 1 ]', '$id[ 2 ]')