如何选择几列之一等于某个值的行? [英] 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屋!