RIGHT(, ) : RIGHT « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. RIGHT

RIGHT(, )

     
mysql>
mysql> SELECT RIGHT('cats and dogs', 4);
+---------------------------+
| RIGHT('cats and dogs', 4) |
+---------------------------+
| dogs                      |
+---------------------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.Return just the MM-DD component of the date with RIGHT()
2.SELECT RIGHT('1995-03-01',5), RIGHT('1996-02-29',5);
3.The following comparison produces a result that is correct in lexical terms but incorrect in temporal terms