Finding field with longest length in a column

mysql string-length
Lizard picture Lizard · Jul 23, 2010 · Viewed 19.4k times · Source

How do I find the field with the longest length of a specific column in a MySQL table?

Answer

fabrik picture fabrik · Jul 23, 2010

MySQL has a lot of string functions you can use:

SELECT LENGTH(col) as my_len FROM my_table ORDER BY my_len DESC LIMIT 1

More funky version (it works):

SELECT MAX(LENGTH(col)) FROM my_table

Related questions

MySQL - How to select data by string length

SELECT * FROM table ORDER BY string_length(column); Is there a MySQL function to do this (of course instead of string_length)?

Read More
SQL SELECT everything after a certain character

I need to extract everything after the last '=' (http://www.domain.com?query=blablabla - > blablabla) but this query returns the entire strings. Where did I go wrong in here: SELECT RIGHT(supplier_reference, CHAR_LENGTH(supplier_…

Read More
Select rows from database by strlen

Is there a way to select database table rows where a given value is a certain length, for example, less than 5 chars long? In PHP that would be strlen. Is there anything similar in MySQL?

Read More