- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- MySQL query to sort by certain last string character?
- MySQL query to replace a string after the last / in a column with directory links?
- How to ORDER BY last 2 character string in MySQL?
- Find the records with % character in a LIKE query with MySQL
- MySQL query to search within the last 5 characters in a column?
- MySQL query to split the string “Learn With Ease” and return the last word?
- MySQL query to display a substring before a special character in a string
- Getting Query String Variables in Express.js
- Find last index of a character in a string in C++
- MySQL query to return 5 random records from last 20 records?
- Getting the last 30 rows in MySQL
- Getting last value in MySQL group concat?
- MySQL Query to remove all characters after last comma in string?
- MySQL query to get a substring from a string except the last three characters?
- How to cut part of a string with a MySQL query?

Advertisements