max value of varchar filed in mysql table

Question

I have a table student with field student_id:

S00254
N52145
FG0255
L30211
S20202
ERS4512

I need to get the result like 52145.

Actually my column student_id mixed with character and number need to find highest value among the rows.

Possible duplicate of [What is the MySQL VARCHAR max size?](http://stackoverflow.com/questions/13506832/what-is-the-mysql-varchar-max-size) — Sumon Sarker, Mar 20 '17 at 06:24
Does every value in this column begin with a single letter, followed by 5 digits? — Tim Biegeleisen, Mar 20 '17 at 06:25

score 0 · Answer 1 · answered Mar 20 '17 at 06:29

0

Assuming that every value in your column ends in a five digit number, then the following should work:

SELECT col
FROM yourTable
ORDER BY CAST(RIGHT(col, 5) AS UNSIGNED) DESC
LIMIT 1

answered Mar 20 '17 at 06:29

Tim Biegeleisen

502,043
27
286
360

score 0 · Answer 2 · answered Mar 20 '17 at 06:48

0

VARCHAR maximum row size 65,535 bytes. It can be store 65,535 characters. learn more https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html

answered Mar 20 '17 at 06:48

Kamrul Hasan

127
1
12

score 0 · Answer 3 · answered Sep 04 '18 at 09:17

Mysql version 5.0.3 varchar can store maximum of 65,535 characters.
But again this limit is having limitation of maximum row size which is 65535 bytes. It means including all columns it should be less than 65,535 bytes.

Detailed blog: http://sforsuresh.in/mysql_varchar_max_length/

max value of varchar filed in mysql table

3 Answers3