right() 方法的语法如下 -
select right(yourcolumnname, valueofn) as anyvariablename from yourtablename;
为了理解上述概念，让我们创建一个表。创建表的查询如下 -
mysql> create table gettinglast5characters −> ( −> bookname varchar(100) −> );query ok, 0 rows affected (0.73 sec)
现在您可以使用插入命令在表中插入记录。查询如下 -
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)
使用 select 语句显示表中的所有记录。显示所有记录的查询如下 -
mysql> select *from gettinglast5characters;
以下是输出 -
+----------------------+| bookname |+----------------------+| introduction to c || c in depth || introduction to java || let us c |+----------------------+4 rows in set (0.00 sec)
这是获取字符串最后 5 个字符的查询 -
mysql> select right(bookname,5) as last5character from gettinglast5characters;
以下是输出 -
+----------------+| last5character |+----------------+| to c || depth || java || us c |+----------------+4 rows in set (0.04 sec)
看看上面的示例输出，空间也在计数。
以上就是使用 mysql 查询获取字符串的最后 5 个字符？的详细内容。