Add hyphen in a string after every 2 characters using in mysql select statement

Question

I have a mysql table with some data. In that i have a column(mobile_number) and that column value is like mobile number (ex:1234587920).

my expected out put is : 12-34-58-79-20

I want to add hyphen after every two numbers.

Answer 1

use concat() for joining strings and use substr() for split a string in mysql :

split (column,start,count) select column from start position for count charachter

concat(column1,"-",column2) will be column1-column2

SELECT CONCAT(SUBSTR(phone,1,2),'-',SUBSTR(phone,3,2),'-',SUBSTR(phone,5,2),'- 
',SUBSTR(phone,7,2),'-',SUBSTR(phone,9,2)) FROM `table`