您可以借助 mysql 的 char_length() 函数按字符长度排序。该函数返回字符数，即以下字符串的 4 个 -
amit
要按字符长度对字符串进行排序，语法如下 -
select *from yourtablename order by char_length(yourcolumnname);
为了理解上面的概念，让我们首先创建一个表。以下是创建表的查询 -
mysql> create table orderbycharacterlength −> ( −> bookname varchar(200) −> );query ok, 0 rows affected (1.97 sec)
借助insert命令在表中插入一些记录。查询如下 -
mysql> insert into orderbycharacterlength values('let us c');query ok, 1 row affected (0.31 sec)mysql> insert into orderbycharacterlength values('introduction to c');query ok, 1 row affected (0.20 sec)mysql> insert into orderbycharacterlength values('data structure and algorithm in java ');query ok, 1 row affected (0.13 sec)mysql> insert into orderbycharacterlength values('c in depth');query ok, 1 row affected (0.17 sec)mysql> insert into orderbycharacterlength values('java projects');query ok, 1 row affected (0.23 sec)
让我们按上表中插入的顺序显示所有记录。查询如下 -
mysql> select *from orderbycharacterlength;
以下是输出 -
+---------------------------------------+| bookname |+---------------------------------------+| let us c || introduction to c || data structure and algorithm in java || c in depth || java projects |+---------------------------------------+5 rows in set (0.00 sec)
这里是显示按照字符长度排列的所有记录的查询。如果列值具有最小长度，那么它将获得更高的优先级并首先显示。
查询如下 -
mysql> select *from orderbycharacterlength order by char_length(bookname);
以下是输出 -
+---------------------------------------+| bookname |+---------------------------------------+| let us c || c in depth || java projects || introduction to c || data structure and algorithm in java |+---------------------------------------+5 rows in set (0.00 sec)
以上就是在 mysql 中按字符长度对字符串进行排序？的详细内容。