sql - Query in MySQL for string fields with a specific length -

how can make mysql query asking string fields in column have particular length?

thanks!

use length() checking length in bytes:

select str sometable length(str) = 5; 

or char_length() checking length in number of characters (useful multi-byte strings):

select str sometable char_length(str) = 5;