Replace character or word using Sql Query

Hi Friends,

Here We learn about how to replace string,character or word to given string using mysql or sql query.For doing this you can use " REPLACE() " Function.

Example :

UPDATE tablename SET fieldname = REPLACE(fieldname,'OLD TEXT','NEW TEXT')