A web developer's blog. PHP, MySQL, CakePHP, Zend Framework, Wordpress, Code Igniter, Django, Python, CSS, Javascript, jQuery, Knockout.js, and other web development topics.

Tag Archives: mysql cast

Type casting in MySQL: Comparing string numbers and getting the right result

Posted on October 22, 2008 by Wenbert Del Rosario

I recently ran into a problem where I had to compare “1000″ and “999″ — take note of the quotes, these values are strings. I did a SUBSTRING() in order to get those 2 strings, er “numbers”. In this SQL … Continue reading →

Posted in General | Tagged , | 3 Comments