Query in MySQL for string fields with a specific length

August 30, 2023 by Tarik

Use LENGTH() for checking length in bytes:

SELECT str FROM sometable WHERE LENGTH(str) = 5;

Or CHAR_LENGTH() for checking length in number of characters (useful for multi-byte strings):

SELECT str FROM sometable WHERE CHAR_LENGTH(str) = 5;