mysql中的max(length(field))

本文介绍了mysql中的max(length(field))的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如果我说:

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