如何配合 WHERE 子句使用 MySQL REVERSE() 函式來處理列資料?
MySQL REVERSE() 函式可以將列名稱作為引數來顛倒其值。如果我們想應用某些條件,可以使用 WHERE 子句,如下所示
示例
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)
上面的查詢顛倒了“Student”表的“Name”列中的值。現在,下面的查詢將使用 REPLACE() 函式和 WHERE 子句
mysql> Select Name, REVERSE(Name) from Student WHERE Subject = 'History'; +-------+---------------+ | Name | REVERSE(Name) | +-------+---------------+ | Aarav | varaA | +-------+---------------+ 1 row in set (0.00 sec)
廣告