menuitem is the table
url is the field
i am trying to change aksharaoffset.com in the field url " http://aksharaoffset.com/Departments/Psychology/About-Us.html"  to 
http://uccollege.edu.in/Departments/Psychology/About-Us.html

basically replace aksharaoffset.com substring with uccollege.edu.in


update menuitem set  url=replace(url,'aksharaoffset.com','uccollege.edu.in')