Articles/SQL

RIGHT() in MySQL — How It Works

What the MySQL RIGHT() function does, with an example.

Published October 18, 2026

RIGHT() returns a specified number of characters from the end (right side) of a string.

Key points

  • Part of standard SQL functions available in MySQL for working with text/strings

Example

SELECT RIGHT('Hello World', 5);  -- 'World'
More SQL articles