length, mysql

User.find(:first, :order => "length(nickname) DESC")

SELECT * FROM `user` ORDER BY length(nickname) DESC LIMIT 1

length, count

SELECT length(todo_name) as l FROM records order by l limit 1;

SELECT COUNT(*) FROM records where todo_name = 'wake_up';