INSTR

INSTR(cadena, subcadena)

SELECT INSTR('MySQL Tutorial', 'Tutorial') AS posicion;

SELECT INSTR('MySQL Tutorial', 'Python') AS posicion;

SELECT nombre, INSTR(nombre, 'Pro') AS posicion_pro
FROM productos
WHERE INSTR(nombre, 'Pro') > 0;

SELECT
    email,
    INSTR(email, '@') AS pos_arroba
FROM clientes
LIMIT 5;

SELECT
    email,
    SUBSTRING(email, 1, INSTR(email, '@') - 1) AS usuario,
    SUBSTRING(email, INSTR(email, '@') + 1) AS dominio
FROM clientes
LIMIT 3;

SELECT INSTR('MySQL Tutorial', 'mysql') AS posicion;