How to get repeated records in mysql?

Another way, it would be:

select  t1.id,
    t1.home_team_name,
    t1.visit_team_name 
    from tu_tabla t1
    inner join ( select     home_team_name,
                visit_team_name 
            from tu_tabla
            group by home_team_name,
                visit_team_name 
            having count(1) > 1
    ) t2
    on t1.home_team_name = t2.home_team_name
    and t1.visit_team_name = t2.visit_team_name

The subquery only retrieves those cases where home_team_name and visit_team_name are repeated by means of group by and having count(1) > 1

You need to look for those records where there is another with the same data, but different id . For this you can create a sub-query with EXISTS

Example:

SELECT M.*
FROM matchs AS M
WHERE EXISTS (
    SELECT 1
    FROM matchs
    WHERE home_team_name = M.home_team_name
        AND  visit_team_name = M.visit_team_name
        AND id != M.id
    LIMIT 1)

Demo

First you must obtain the list of repeated cases, to later list each one of them

For example:

select id, home_team_name, visit_team_name
from mytable 
where home_team_name in (
    select home_team_name
    from mytable 
    group by  home_team_name
    having count(*)>1)

To see which ones have duplicates, the query would be:

SELECT * FROM mitabla 
INNER JOIN 
(SELECT home_team_name FROM mitabla GROUP BY home_team_name, visit_team_name HAVING COUNT(*)>1) sel
ON mitabla.home_team_name = sel.home_team_name

You need to see the records within those that are duplicated for the fields that interest you, which are collected in the parentheses selection.