Sprobuj:
LENGTH(str)
Returns the length of the string str, measured in bytes. A multi-byte character counts as multiple bytes. This means that for a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.
mysql> SELECT LENGTH('text');
-> 4
albo
CHAR_LENGTH(str)
Returns the length of the string str, measured in characters. A multi-byte character counts as a single character. This means that for a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.
oczywiscie z maxem, czyli cos w stylu
select imie from tabela where length(imie) = (select max(length(imie)) from tabela)
oczywiscie, jesli masz mysql'a obslugujacego podzapytania (>4.1). Jak nie to zapamietaj maxa po jednym zapytaniu i wykonaj drugie juz z okreslona liczbowo dlugoscia.
pozdrawiam
johny