SQL Basics | Functions | Replace

Tags:

In SQL, the Replace function is used to replace part of the data in a field. The function name differs by database.

  • MySQL: REPLACE()

Replace syntax

REPLACE() is used as follows.

REPLACE('string', 'string_to_replace', 'replacement_string')

Replace example

SELECT REPLACE('abcdefg', 'abc', 'aaa');

The result is as follows.

| REPLACE('abcdefg', 'abc', 'aaa') |
|--|
| aaadefg |