如果我正确理解了您的问题:

If I understand your question correctly:

SELECT * FROM tbl WHERE id = 123 OR colname4 = 'x' OR colname8 = 'y' LIMIT 1

"LIMIT"关键字确保只有一行返回.