Mysql Question

[Nails]

Is there anyway using mysql only you can do a

select * from table where str_length('password') < 5

So way to get a return of all passwords with less then 5
characters in them?

Or do I need to use php?

[BigBen]

SELECT * FROM table WHERE CHAR_LENGTH(password) < 5;

[Iron Fist]

Last to the party