Query in MySQL for string fields with a specific length

Question

How can I make a MySQL query asking for all the string fields in a column that have a particular length?

Thanks!

BoltClock · Accepted Answer · 2011-02-09 02:59:32Z

66

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;

answered Feb 9, 2011 at 2:59

BoltClock

728k165 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John K. · Accepted Answer · 2011-02-09 03:00:33Z

6

select * 
from myTable 
where length(myColumn) = 5

answered Feb 9, 2011 at 3:00

John K.

5,4741 gold badge23 silver badges20 bronze badges