你可以简单地使用 exists :

select t.*
from t
where exists (select 1
              from t t2
              where t2.kivuto_id = t.kivuto_id and
                    t2.region_id <> t.region_id
             );

为了提高性能，您需要一个索引 (kivuto_id, region_id) .

试试这个。

select * from table_name 
  where kivuto_id in (
    select email from table_name
      group by kivuto_id
      having count(*) > 1
  )

您也可以参考：在mysql中查找列上具有相同值的行