Tuesday 2 August 2016

REVERSE() : Reverse the string



REVERSE(str): Reverse the characters in string.

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

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





Previous                                                 Next                                                 Home

No comments:

Post a Comment