MYSQL: Values of a column where two other columns have same value
You mean something like

SELECT col2, col3 FROM table WHERE col2 = col3 GROUP BY col2, col3 
HAVING COUNT(DISTINCT col1) &gt; 1;


Would show you the col2/col3 combinations where col2 = col3 but col1 differs between those rows.