MySQL8 REVERSE() Functions – String Functions

by · Published · Updated

REVERSE() functions return the string with the order of the characters reversed.

Returns NULL if the argument is NULL.

Note: This function is multibyte safe.

MySQL REVERSE() Functions: Syntax

REVERSE ( string );

MySQL REVERSE() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|left|left|left”]
Name, Required /Optional,Type, Description
string, Required, String , It represents the valid input string.
[/table]

MySQL REVERSE() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Return, Description
string, returns the reversed string.
NULL, if the argument is NULL.[/table]

MySQL REVERSE() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

REVERSE() Example 1 : Very easy example

Below is an example to reverse one word.

mysql> SELECT REVERSE('tutorialmines!');
+---------------------------+
| REVERSE('tutorialmines!') |
+---------------------------+
| !senimlairotut            |
+---------------------------+
1 row in set (0.00 sec)

REVERSE() Example 2 : Many Words

Below is an example to reverse many words.

mysql> SELECT REVERSE('This is tutorialmines site for all!');
+------------------------------------------------+
| REVERSE('This is tutorialmines site for all!') |
+------------------------------------------------+
| !lla rof etis senimlairotut si sihT            |
+------------------------------------------------+
1 row in set (0.05 sec)

REVERSE() Example 3 : Exploring in database

In the employee table, the name Column has been reversed. Below is an example to show it.

mysql> select name, REVERSE(name) from tbl_employee;
+------------+---------------+
| name       | REVERSE(name) |
+------------+---------------+
| Jyoti Rani | inaR itoyJ    |
| Polla      | alloP         |
| Arnav      | vanrA         |
| Jeevesh    | hseveeJ       |
| Tom        | moT           |
+------------+---------------+
5 rows in set (0.00 sec)

REVERSE() Example 4  : NULL arguments

If the arguments are NULL, it will return NULL. See below example

mysql> SELECT REVERSE(NULL);
+---------------+
| REVERSE(NULL) |
+---------------+
| NULL          |
+---------------+
1 row in set (0.00 sec)

mysql> SELECT REVERSE(Concat('Bat',NULL));
+-----------------------------+
| REVERSE(Concat('Bat',NULL)) |
+-----------------------------+
| NULL                        |
+-----------------------------+
1 row in set (0.16 sec)

See all MySQL String functions MySQL 8 String Functions.

Related articles : LOCATE(), HEX(), CONCAT(), CONCAT_WS() , LOWER(), LTRIM(), INSTR(), POSITION().

PHP Related articles : STRREV() ,STR_REPLACE(), SUBSTR_REPLACE(), STR_REPEAT(), STR_PAD(), STRREV(), PHP STRING FUNCTIONS().

You may also like...