mysql中的max(length(field)) [英] max(length(field)) in mysql

问题描述

如果我说:

select max(length(Name)) 
  from my_table

我得到的结果为18，但是我也想要有关的数据.所以，如果我说:

I get the result as 18, but I want the concerned data also. So if I say:

select max(length(Name)), 
       Name 
  from my_table

...它不起作用.我猜应该有一个自我联接，我无法弄清楚.

...it does not work. There should be a self join I guess which I am unable to figure it out.

任何人都可以给我一个线索吗?

Can anyone please provide me a clue?

推荐答案

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

这篇关于mysql中的max(length(field))的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！