max(length(field)) in mysql

January 13, 2023 by Tarik

SELECT  name, LENGTH(name) AS mlen
FROM    mytable
ORDER BY
        mlen DESC
LIMIT 1