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?
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 company 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)