SQL TRANSLATE Function

Example

Return the string from the first argument AFTER the characters specified in the second argument are translated into the characters specified in the third argument:

SELECT TRANSLATE('Monday', 'Monday', 'Sunday'); // Results in Sunday

Definition and Usage

The TRANSLATE() function returns the string from the first argument after the characters specified in the second argument are translated into the characters specified in the third argument.

Note: The TRANSLATE() function will return an error if characters and translations have different lengths.

Syntax

TRANSLATE(string, characters, translations)

Continue reading SQL TRANSLATE Function