SQL哪个语句可以进行查询同一个表里的4个列的值是一样的？

Answer 1

楼上的是模糊查找 应该不是楼主要的答案吧 不应该用 like 吧
应该这样吧
如果要是知道值的话 把李四换成你知道的值
select * from A where a1 = '李四' and a2= '李四' and a3 = '李四' and a4 = '李四'
如果不知道值的话只知道他们是相等的用这个
select * from aa where a=a1 and a=a2 and a=a3

Answer 2

select * from A where a1 like '%李四%' and a2 like '%李四%' and a3 like '%李四%' and a4 like '%李四%'

Answer 3

select * from table where column1 = column2 and column2 = column3 and column3 = column4

Answer 4

SELECT * FROM TABLE WHERE AA= BB AND AA = CC AND AA= DD AND AA = EE