mysql - Finding field with longest length in a column -


how find field longest length of specific column in mysql table?

mysql has lot of string functions can use:

select length(col) my_len my_table order my_len desc limit 1 

more funky version (it works):

select max(length(col)) my_table 

Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -