Getting last 5 character of a string with MySQL query?

To get the first n characters of string with MySQL, use LEFT(). To get the last n char of string, the RIGHT() method is used in MySQL.

The syntax for RIGHT() method is as follows −

SELECT RIGHT(yourColumnName, valueOfN) as anyVariableName from yourTableName;

To understand the above concept, let us create a table. The query to create a table is as follows −

mysql> create table gettingLast5Characters
   −> (
   −> BookName varchar(100)
   −> );
Query OK, 0 rows affected (0.73 sec)

Now you can insert records in the table using insert command. The query is as follows −

mysql> insert into gettingLast5Characters values('Introduction to C');
Query OK, 1 row affected (0.19 sec)

mysql> insert into gettingLast5Characters values('C in Depth');
Query OK, 1 row affected (0.18 sec)

mysql> insert into gettingLast5Characters values('Introduction to Java');
Query OK, 1 row affected (0.18 sec)

mysql> insert into gettingLast5Characters values('Let us C');
Query OK, 1 row affected (0.51 sec)

Display all records from the table using select statement. The query to display all records is as follows −

mysql> select *from gettingLast5Characters;

The following is the output −

+----------------------+
| BookName             |
+----------------------+
| Introduction to C    |
| C in Depth           |
| Introduction to Java |
| Let us C             |
+----------------------+
4 rows in set (0.00 sec)

Here is the query that gets the last 5 character of string −

mysql> select RIGHT(BookName,5) as Last5Character from gettingLast5Characters;

The following is the output −

+----------------+
| Last5Character |
+----------------+
| to C           |
| Depth          |
| Java           |
| us C           |
+----------------+
4 rows in set (0.04 sec)

Look at the above sample output, space is counting also.

Vrundesha Joshi

Published on 16-Jan-2019 08:11:19

• Related Questions & Answers
• MySQL query to sort by certain last string character?
• MySQL query to search within the last 5 characters in a column?
• MySQL query to return 5 random records from last 20 records?
• MongoDB query to skip first 5 records and display only the last 5 of them
• Getting Query String Variables in Express.js
• MySQL query to replace a string after the last / in a column with directory links?
• Getting the last 30 rows in MySQL
• Getting last value in MySQL group concat?
• Find last index of a character in a string in C++
• How to ORDER BY last 2 character string in MySQL?
• Find the records with % character in a LIKE query with MySQL
• Finding the last occurrence of a character in a String in Java
• MySQL query to display a substring before a special character in a string
• MySQL String Last Index Of in a URL?
• How to cut part of a string with a MySQL query?