Find higest value

SELECT MAX(ringtime) FROM `south`

Is returning 9 from the below colum any ideas why it’s not 23?

9 is the highest string value. Are you wanting the highest numeric value!

ah yes please :slight_smile:

would

SELECT ringtime FROM north ORDER BY ABS(ringtime) DESC

be correct?

This worked and just changed the structure to int also

Try this:

[TABLE]
[TR]
[TD=“class: votecell”][CENTER]6down voteaccepted[/CENTER]
[/TD]
[TD=“class: answercell”]Do not mixed varchar with numeric,
idea solution is only stored numeric for used of max aggregate function,
alternatively
max( cast(value as unsigned) )When you are doing a MAX, is a cast to string.
When you are doing comparison, is a cast to numeric.
Reason?
http://dev.mysql.com/doc/refman/5.0/en/

[/TD]
[/TR]
[/TABLE]