MySQL-如何通过字符串长度选择数据

叁歲伎倆 2022-11-27 12:04 128阅读 0赞

本文翻译自：[MySQL - How to select data by string length][]

SELECT * FROM table ORDER BY string_length(column);

是否有MySQL函数可以执行此操作（当然不是`string_length` ）？

--------------------

### \#1楼 ###

参考：[https://stackoom.com/question/7QIp/MySQL-如何通过字符串长度选择数据][https_stackoom.com_question_7QIp_MySQL-]

--------------------

### \#2楼 ###

看一下有关字符串函数的[MySQL文档][MySQL] ，我们还可以使用`CHAR_LENGTH()`和`CHARACTER_LENGTH()` 。

--------------------

### \#3楼 ###

*You are looking for [`CHAR_LENGTH()`][CHAR_LENGTH] to get the number of characters in a string.* **您正在寻找[`CHAR_LENGTH()`][CHAR_LENGTH]以获取字符串中的字符数。**

*For multi-byte charsets [`LENGTH()`][LENGTH] will give you the number of bytes the string occupies, while `CHAR_LENGTH()` will return the number of characters.* **对于多字节字符集， [`LENGTH()`][LENGTH]将为您提供字符串占用的字节数，而`CHAR_LENGTH()`将返回字符数。**

--------------------

### \#4楼 ###

select * from table order by length(column);

有关length（）函数以及所有其他字符串函数的文档，请参见[此处][Link 1] 。

--------------------

### \#5楼 ###

我用来查找字符串`length`的函数是`length` ，用法如下：

SELECT * FROM table ORDER BY length(column);

--------------------

### \#6楼 ###

select * from *tablename* where 1 having length(*fieldname*)=*fieldlength*

例如，如果您想从客户中选择名称短于2个字符的条目。

select * from customer where 1 **having length(name)<2**

[MySQL - How to select data by string length]: https://oldbug.net/q/7QIp/MySQL-How-to-select-data-by-string-length
[https_stackoom.com_question_7QIp_MySQL-]: https://stackoom.com/question/7QIp/MySQL-%E5%A6%82%E4%BD%95%E9%80%9A%E8%BF%87%E5%AD%97%E7%AC%A6%E4%B8%B2%E9%95%BF%E5%BA%A6%E9%80%89%E6%8B%A9%E6%95%B0%E6%8D%AE
[MySQL]: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
[CHAR_LENGTH]: https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_char-length
[LENGTH]: https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length
[Link 1]: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length