How to add certain string to a url via mysql?

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

Login your phpmyadmin, and choose the related database, here, let us say the table contains the company url is “dede_co_htmls”, and the field that store each comapany url is “url”, run the following code:
update dede_co_htmls set url = concat(url,"/company_profile.html");

MySQL REPLACE() replaces all the occurrences of a substring within a string.
Syntax: REPLACE(str, find_string, replace_with)