I have a table "videodb" and the column "title" is VARCHAR.
I can get the title with maximum length using one of the following SQLs.
Approach 1
SELECT title, LENGTH(title) AS title_lenFROM videodbORDER BY title_len DESC LIMIT 1
Approach 2
SELECT max(LENGTH(title)) AS title_lenFROM videodb