查找超过三列在mysql中具有相等的值 [英] Find more than three columns having equal value in mysql

问题描述

我有多个列具有相等的值.我想查找具有3列以上具有相等值的行ID.

I have multiple columns have equal value. I want to find the row id which have more than 3 columns have equal value.

@each column is text/blob

表结构类似于-

id  col1 col2 col3 col4 col5 col6 col7 col8 col9

推荐答案

Unpivot数据并检查是否相等，请尝试以下技巧.

Unpivot the data and check for equality, Try this trick.

SELECT DISTINCT id 
FROM   (SELECT id,col1 AS col from Yourtable
        UNION ALL 
        SELECT id,col2  from Yourtable
        UNION ALL 
        SELECT id,col3  from Yourtable
        UNION ALL 
        SELECT id,col4  from Yourtable
        Union ALL
        .......) A 
GROUP  BY id,col 
HAVING Count(1) > 3 

这篇关于查找超过三列在mysql中具有相等的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！