How to get specific values from a STRING in MYSQL

Question

I want equivalent of explode() to work with strings in MySQL

I have a Cloumn Value in DB is "REF/123456-0001"

I need a value of only 123456

Answer 1

Use

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(column,'-', 1),'/',-1) as value