Specify string length in query

[Nibster]

Is it possible to specify a string length when doing a MySQL query? I have a dictionary and want to select words that are only 5 characters long.

I could always loop through the results in PHP and weed out words that don't meet the specified length, but I was just wondering if that can be done in the initial query.

Thanks in advance,
Nibbi

[Lars_Berg]

where char_length(<columnName)>)  = 5

[Nibster]

Lars Berg wrote:

where char_length(<columnName)>)  = 5

Thank you.

I tried that but I get the following error:

#1305 - FUNCTION testTable.char_length does not exist

Here is the query

SELECT word
FROM spell_words
WHERE char_length(word) = 5

if it makes any difference, I am running MySQL 5.0.15 on PHP 5

[Yegg]

try to use synonyms for onebyte charcodes: length(<column_name>) or character_length(column_name>). but be careful if you will use them for multibite charsets like UTF8, they will give different results - ones as BYTE length another as character length.

[Drakla]

use LENGTH() instead of char_length()

[Nibster]

length(<column_name>) worked perfectly.

SELECT word
FROM spell_words
WHERE length(word) = 5

Thank you very much, everyone.

Regards