In order to revise the data of a specific string, a function Replace is used in SQL. The way of calling this function is same in Oracle, SQL Server and MySQL. It is REPLACE(). The structure for this function is given below;
Replace(str2, str3, str4): its way is quite interesting. It finds the position of str3 in str2. It replaces the str4 in str3.
We can understand it with the help of this table;
West Los Angeles
West San Diego
East New York
This function can be utilized like this;