mysql> select right(" dedede",6);+---------------------+| right(" dedede",6) |+---------------------+| dedede |+---------------------+1 row in set (0.00 sec)mysql> select right(" dedede",3);+---------------------+| right(" dedede",3) |+---------------------+| ede |+---------------------+1 row in set (0.00 sec)