Get maximum field length in mysql

redlorry919

Hello,

Does anyone know how to get the field with the longest value in it, via mysql?

i.e. if I have the following:

1 - 1234
2 - 123
3 - 43242
4 - 2342342
5 - 21
6 - 4334

To run a query that returns the fourth record and preferably the length.

The idea behind this is to display each table/field name and max field length with the database (done) and then list beside it the current largest field item so I can trim the max field length values.

I hope this isn't too confusing!?

Thanks in advance,
Adam.

mrhappiness

SELECT column, LENGTH(column) columnlength
FROM table
ORDER BY LENGTH(column) DESC
LIMIT 1

paulnaj

Hi Adam,

Not sure about doing it in one query ...

SELECT MAX( LENGTH( 'field') ) FROM table

... will get you the longest value though.

Paul.

mrhappiness

Originally posted by paulnaj
SELECT MAX( LENGTH( 'field') ) FROM table

will return 5 as the string "field" is 5 characters long 😉

redlorry919

Spot on! Thanks for the responses, I've got it going a treat now.

Thanks again,
Adam.

paulnaj

will return 5 as the string "field" is 5 characters long

Er, you would be supposed to work out how to put the actual name of the field in it's place for yourself, of course.

Paul 😉

redlorry919

Yeah, dont worry 'I' twigged that! 🙂

Thanks,
Adam.