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.
Published on 16-Jan-2019 12:41:19
