Como splitar valor de columnas

[neodani]

Holas!

Estoy intentando sacar los partidos cuyo resultado sea la victoria del equipo local, pero no me da un error de sintaxis que no consigo ver.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where CAST(SUBSTRING_INDEX(`ht`, '-', -1) AS SIGNED) > (CAST(SUBSTRING_INDEX(`ht' at line 6

Código SQL:

SELECT
    home `Local`,
    CAST(SUBSTRING_INDEX(`ht`, '-', -1) AS SIGNED) Goles,
    away `Visitante`,
    CAST(SUBSTRING_INDEX(`ht`, '-', 1) AS SIGNED) Goles
    WHERE CAST(SUBSTRING_INDEX(`ht`, '-', -1)) > (CAST(SUBSTRING_INDEX(`ht`, '-', 1))
FROM partidos;
 

Código SQL:

SELECT
    home `Local`,
    CAST(SUBSTRING_INDEX(`ht`, '-', -1) AS SIGNED) Goles,
    away `Visitante`,
    CAST(SUBSTRING_INDEX(`ht`, '-', 1) AS SIGNED) Goles
    WHERE CAST(SUBSTRING_INDEX(`ht`, '-', -1) AS SIGNED) > (CAST(SUBSTRING_INDEX(`ht`, '-', 1) AS SIGNED)
FROM partidos;
 

Código SQL:

SELECT
    home `Local`,
    CAST(SUBSTRING_INDEX(`ht`, '-', -1) AS SIGNED) Goles,
    away `Visitante`,
    CAST(SUBSTRING_INDEX(`ht`, '-', 1) AS SIGNED) Goles,
    IF(CAST(SUBSTRING_INDEX(`ht`, '-', -1) AS SIGNED) > CAST(SUBSTRING_INDEX(`ht`, '-', 1) AS SIGNED), 'Local')
FROM partidos;
 

Qué hago mal?

Gracias de antemano!