2 Topics

Member Avatar for
Member Avatar for mwenyenia07
Max from varchar column fails beyond 999
Share on Facebook Share on Twitter Share on LinkedIn

I want to get the max(id) from a table colum with variable characters. it always returns 999 as the highest yet I have values like 6008 or even over 10000. I have tried the following: 1. SELECT Max(column_name) from table_name where column_name REGEXP '^[0-9]+$' 2. isNumeric as one of the …

Databases isnumeric mysql
Member Avatar for Casperjames
0
2
531
Member Avatar for vegaseat
A Python module 'isnumeric'
Share on Facebook Share on Twitter Share on LinkedIn

A simple test of a numeric string.

Software Development isnumeric python
Member Avatar for BearofNH
1
12
2K

The End.