Extract a substring from a string

SELECT SUBSTR("SQL Tutorial", 5, 3) AS ExtractString;

https://www.w3schools.com/sql/func_mysql_substr.asp

SUBSTR(MA.REFERENCE_ID, 1, 8) = SUBSTR(EA.REFERENCE_ID, 1, 8)