Get last 5 characters of string using MySQL query?

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

The syntax of 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 the table is as follows -

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

Now you can use insert command to insert records in the table. 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)

Use the select statement to display all records in the table. 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)

This is the query to get the last 5 characters of the 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 example output above, the space is also counting.

The above is the detailed content of Get last 5 characters of string using MySQL query?. For more information, please follow other related articles on the PHP Chinese website!