How To Select the Max Numeric in a Varchar Column in MySQL

Author: , October 2nd, 2015

I needed to automate the addition of new users with a sequential member’s ID in WordPress. Additionally, there were non-numeric entries in that column that had to be ignored. The wp_users.user_login column is a varchar(60) and so does not naturally handle numeric operations well at all. The solution is a combination of REGEXP and cast(): […]

How To Select Only Numeric Values From MySQL

Author: , September 6th, 2012

How To Determine If A String Is An Integer In Perl

Author: , October 28th, 2011

This solution is hyper-simplistic, and does not deal with decimals or real numbers (those with either a – or a + in front of them)…