over 9 years ago
REVERSE(str)
If you want to reverse a string in mysql then you can use the REVERSE(str) mysql function. REVERSE() function returns the string str with the order of the characters reversed means if you want to reverse a string then you can pass the string as a argument in this function.
- mysql> SELECT REVERSE('HELLO MySQL');
- +------------------------+
- | REVERSE('HELLO MySQL') |
- +------------------------+
- | LQSyM OLLEH |
- +------------------------+
- 1 row in set (0.00 sec)
- mysql> SELECT REVERSE('MySQL');
- +------------------+
- | REVERSE('MySQL') |
- +------------------+
- | LQSyM |
- +------------------+
- 1 row in set (0.00 sec)
mysql> SELECT REVERSE('HELLO MySQL');
+------------------------+
| REVERSE('HELLO MySQL') |
+------------------------+
| LQSyM OLLEH |
+------------------------+
1 row in set (0.00 sec)
mysql> SELECT REVERSE('MySQL');
+------------------+
| REVERSE('MySQL') |
+------------------+
| LQSyM |
+------------------+
1 row in set (0.00 sec)
0 Comment(s)