SUBSTRING_INDEX

SUBSTRING_INDEX(cadena, delimitador, conteo)

SELECT SUBSTRING_INDEX('www.mysql.com', '.', 1) AS resultado;

SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2) AS resultado;

-- Conteo negativo: desde el final
SELECT SUBSTRING_INDEX('www.mysql.com', '.', -1) AS resultado;

SELECT SUBSTRING_INDEX('www.mysql.com', '.', -2) AS resultado;

SELECT
    email,
    SUBSTRING_INDEX(email, '@', -1) AS dominio,
    SUBSTRING_INDEX(email, '@', 1) AS usuario
FROM clientes
LIMIT 5;

SELECT
    nombre,
    apellidos,
    SUBSTRING_INDEX(apellidos, ' ', 1) AS primer_apellido,
    SUBSTRING_INDEX(apellidos, ' ', -1) AS segundo_apellido
FROM clientes
LIMIT 5;

SELECT
    SUBSTRING_INDEX('iPhone,1299.99,50', ',', 1) AS nombre,
    SUBSTRING_INDEX(SUBSTRING_INDEX('iPhone,1299.99,50', ',', 2), ',', -1) AS precio,
    SUBSTRING_INDEX('iPhone,1299.99,50', ',', -1) AS stock;

SELECT
    nombre,
    SUBSTRING_INDEX(nombre, ' ', 1) AS marca
FROM productos
LIMIT 5;

SELECT SUBSTRING_INDEX('sin-punto', '.', 1) AS resultado;