MySQL 通过 strlen 从数据库中选择行

Select rows from database by strlen

提问by santa

Is there a way to select database table rows where a given value is a certain length, for example, less than 5 chars long?

有没有办法选择给定值具有特定长度（例如，长度小于 5 个字符）的数据库表行？

In PHP that would be strlen.

在 PHP 中，这将是strlen.

Is there anything similar in MySQL?

MySQL中有没有类似的东西？

回答by Derek Prior

SELECT * FROM table_name WHERE CHAR_LENGTH(column_name) < 5

回答by Timo Huovinen

LENGTH("my_string")Return the length of a string in bytes

LENGTH("my_string")以字节为单位返回字符串的长度

SELECT * FROM table_name WHERE LENGTH(column_name) < 5

Keep in mind that characters can be made up of multiple bytes like those in UTF-8.

请记住，字符可以由多个字节组成，如 UTF-8 中的字节。