title: max(length(field)) in mysql
body: <p>If I say:</p>
  
  <pre><code>select max(length(Name)) 
    from my_table
  </code></pre>
  
  <p>I get the result as 18, but I want the concerned data also.  So if I say:</p>
  
  <pre><code>select max(length(Name)), 
         Name 
    from my_table
  </code></pre>
  
  <p>...it does not work. There should be a self join I guess which I am unable to figure it out.</p>
  
  <p>Can anyone please provide me a clue?</p>