reverse

Reverses the order of characters in a string.

The returned value is the same length as the input, but with the characters in reverse order. If subject is NULL, the result is also NULL.

Syntax

reverse(<subject>)

Examples

This example reverses a string:

SELECT reverse('Hello, world!');

+--------------------------+
| reverse('Hello, world!') |
+--------------------------+
| !dlrow ,olleH            |
+--------------------------+