How can we use MySQL REVERSE() function on column’s data along with WHERE clause?
MySQL REVERSE() function can have the column name as an argument to invert its value. If we want to apply some condition/s then it can be used along with WHERE clause as follows:
Example
mysql> Select Name, REVERSE(Name) from Student;
+---------+---------------+
| Name | REVERSE(Name) |
+---------+---------------+
| Aarav | varaA |
| Gaurav | varuaG |
| Gaurav | varuaG |
| Harshit | tihsraH |
| Yashraj | jarhsaY |
+---------+---------------+
5 rows in set (0.00 sec)
The above query inverts the values of ‘Name’ column from ‘Student’ table. Now, the query below will use the REPLACE() function with WHERE clause:
mysql> Select Name, REVERSE(Name) from Student WHERE Subject = 'History';
+-------+---------------+
| Name | REVERSE(Name) |
+-------+---------------+
| Aarav | varaA |
+-------+---------------+
1 row in set (0.00 sec)
Published on 20-Feb-2018 15:59:03
