Takea look at this
SELECT REGEXP_SUBSTR(.....) # Tutorial below
https://www.mysqltutorial.org/mysql-regular-expressions/mysql-regexp_substr/