How do I find the longest value in my mysql table?
So you probably know that the LENGTH() function applied to a fieldname will return the length of that field.
So then all you need is the relevant query to find the length of the longest item in a field like so:
<?php
$q = mysql_query("SELECT LENGTH(firstname) AS thelength FROM myfriends ORDER BY thelength DESC LIMIT 1");
$longestname = mysql_result($q,0,0);
echo "The longest first name is $longestname letters long!";
?>
Comment on this Question and Answer >>>
ASK A QUESTION
More mysql PHP Questions
How do I set a default value for ENUM fields in PHP?How do I group the results of a mysql query?
I am unable to make pages for my search result.Below I am giving the code that I am using. Career Search result Yami says
What is difference between mysql_fetch_array and mysql_fetch_object?
How do I find second highest value from a table?
