根据单个值检查多个 MySQL 列 [英] Checking multiple MySQL columns against a single value

问题描述

我有一个非常简单的问题:如何根据单个值检查多个 MySQL 列?我基本上在寻找 IN (1, 2, 3, 4) 的反面，其中可以根据多个值检查单个列.

I have a very simple question: how can I check multiple MySQL columns against a single value? I'm looking basically for the opposite of the IN (1, 2, 3, 4) where one can check a single column against multiple values.

我知道我只能写多个句子，但我一直在寻找更优雅的解决方案.我正在使用 PHP.谢谢！

I know I can just write multiple sentences, but I was looking for a more elegant solution. I'm using PHP. Thank you!

推荐答案

仅使用 IN 如下:

select * from TableName where 2 IN (ColumnOne,ColumnTwo,ColumnThree)

这篇关于根据单个值检查多个 MySQL 列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！