How to add certain string to a URL via MySQL?

Listen, if you have 10,000 companies’ URLs at your MySQL, now you need to add about-us.html just after each URL, for example, one of your company URLs is absorking-desiccat, how to let it become to absorking-desiccant/company_profile.html?