Make a simple format (MySQL)

Question

The goal

Convert 99999999 into 99999-999.

The problem

I do not know the syntax.

What I already thought about

I was thinking to useFORMAT() function — but I'm working with INT instead of DECIMAL.

My query

Select city.ZipCode As zipCode
From app_cities As city
Where city.Id = 1

So, that's it. Someone has any idea to me?

Answer 1

Use INSERT()

select insert(ZipCode , 6, 0, '-') As zipCode
from app_cities As city
where Id = 1

SQLFiddle demo