max length field in mysql

Question

If I say   select max length Name      from my table   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

User · Answer

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

User · Answer

Ok  I am not sure what are you using MySQL  SLQ Server  Oracle  MS Access    But you can try the code below  It work in W3School example DB  Here  try this    SELECT city  max length city   FROM Customers

User · Answer

Select URColumnName From URTableName Where length URColumnName   IN   Select max length URColumnName   From URTableName     This will give you the records in that particular column which has the maximum length

User · Answer

In case you need both max and min from same table       select   from    select city  length city  as maxlen from station order by maxlen desc limit 1  union  select city  length city  as minlen from station order by minlen city limit 1  a

User · Answer

select    from my table  where length  Name              select max  length  Name            from my table       limit 1       It this involves two table scans  and so might not be very fast

User · Answer

Use     SELECT mt name      FROM MY TABLE mt GROUP BY mt name   HAVING MAX LENGTH mt name     18      assuming you know the length beforehand   If you don t  use     SELECT mt name      FROM MY TABLE mt     JOIN  SELECT MAX LENGTH x name  AS max length             FROM MY TABLE x  y ON y max length   LENGTH mt name

User · Answer

I suppose you could use a solution such as this one    select name  length name  from users where id         select id     from users     order by length name  desc     limit 1      Might not be the optimal solution  though    But seems to work

User · Answer

Use CHAR LENGTH   instead-of LENGTH   as suggested in   MySQL - length   vs char length    SELECT name  CHAR LENGTH name  AS mlen FROM mytable ORDER BY mlen DESC LIMIT 1

User · Answer

Edited  will work for unknown max   values   select name  length  name   from my table where length  name       select max  length  name     from my table

[sql] max(length(field)) in mysql

Examples related to sql

Examples related to mysql