如何选择几列之一等于某个值的行? [英] how to select a row where one of several columns equals a certain value?

问题描述

说我有一个包含A列，B列和C列的表.如何编写查询以选择A列或B列或C列等于某个值的所有行?谢谢.

Say I have a table that includes column A, column B and column C. How do I write I query that selects all rows where either column A OR column B OR column C equals a certain value? Thanks.

更新:我认为忘记提及我的困惑了.假设还有另一列(第1列)，我需要根据以下逻辑进行选择:

Update: I think forgot to mention my confusion. Say there is another column (column 1) and I need to select based on the following logic:

......其中Column1 ='..'AND(ColumnA ='..'OR ColumnB ='..'OR ColumnC ='..')

...where Column1 = '..' AND (ColumnA='..' OR ColumnB='..' OR ColumnC='..')

像上面用括号一样对语句进行分组以获得所需的逻辑是否有效?

Is it valid to group statements as I did above with parenthesis to get the desired logic?

推荐答案

除非我在这里遗漏了一些东西...

Unless I'm missing something here...

SELECT * FROM MYTABLE WHERE COLUMNA=MyValue OR COLUMNB=MyValue OR COLUMNC=MyValue

这篇关于如何选择几列之一等于某个值的行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！