How to extract the maximum value from a text field in MySql?

Question

MySQL

id | value
1 | 3
2 | 24
3 | -5
4 | 2
5 | 2006
| 99
SELECT MAX(value) FROM `test`
Gives 99, but should be 200

Answer 1

Try it like this:
SELECT MAX(CAST(value AS UNSIGNED)) FROM `test`

Answer 2

200 > 99
'99' > '200'