mysql - How to find IDs with multiple values in other column?

Question

Closed. This question needs details or clarity. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65949849/how-to-find-ids-with-multiple-values-in-other-column

Answer 1

You can use EXISTS as follows:

SELECT *
FROM mytable as t1
    WHERE exists (                  
    SELECT 1                  
    FROM mytable as t2             
    WHERE t2.customer = t1.customer
      and t2.usually_same <> t1.usually_same)