Skip to main content Link Menu Expand (external link) Document Search Copy Copied

REVERSE() function

Reverse() function reverses all instances of a specified string in the selected column.

Syntax

reverse(expr)

Arguments

Argument Description
expr Any string expression.

Returns

Data type Value
string Reversed expr string.

Examples

Reverse strings in a column

create table segments
    (_id id, segment string);

insert into segments(_id,segment)
    values (1,'green')

select _id, reverse(segment) as reversed from segments;
+-----+----------+
| _id | reversed |
+-----+----------+
|   1 | neerg    |
+-----+----------+

Nested reverse function

A nested reverse function reverses the string, then reverses it back.

create table segments
    (_id id, segment string);

insert into segments(_id,segment)
    values (1,'red')

select _id, reverse(reverse(segment)) as segment from segments;
+-----+----------+
| _id | reversed |
+-----+----------+
|   1 | red      |
+-----+----------+