MySql database has very simple and easy to use string function REPLACE() that is used to find any string and…