Which function in MySQL is used to reverse a particular string?


MySQL REVERSE() function can be used to reverse a string. Following example will demonstrate it −

mysql> Select REVERSE('Tutorialspoint');
+---------------------------+
| REVERSE('Tutorialspoint') |
+---------------------------+
| tniopslairotuT            |
+---------------------------+
1 row in set (0.00 sec)

mysql> Select Reverse('10-11-12');
+---------------------+
| Reverse('10-11-12') |
+---------------------+
| 21-11-01            |
+---------------------+
1 row in set (0.00 sec)

Updated on: 22-Jun-2020

51 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements