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