mysql where

[sheephat]

Hello folks, is it possible to do this

i have this query

SELECT word FROM table WHERE auto =' ' ORDER BY RAND() LIMIT 0,1

is it posible to a a where to select only words which are less than 5 characters long. like: WHERE str_lenght(word) <= 5.

Sorry if that doesnt make sense, but still with the hope it does i appreciate any help you can give. Thanks.

[leatherback]

I think there is a strlen(FIELDNAME) function.

select word from table where strlen(word) < 5

could work?

[NogDog]

MySQL string functions
The LENGTH() function