How can we use MySQL REVERSE() function on column’s data along with WHERE clause?

MySQLMySQLi Database

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)
raja
Published on 20-Feb-2018 11:29:03
Advertisements