MySQL statement select where a column is NOT a number
mysql, php, sql
Solution
RegExp works, but what I would do is check to see if abs() is equal to zero AND the field is not zero. I think this will be faster than RegExp.
SELECT id, area, city FROM `homes` WHERE (abs(area) = 0 AND area != '0') OR (abs(city) = 0 AND city != '0')
Problem
I have a problematic script that ran, so i need to select all rows that contain values that is not a straight up integer. How do I do this? ISSTRING was on a Google search but I get an error from it saying ISSTRING does not exist. :( So far I've muddled with: ``` SELECT id, area, city FROM `homes` WHERE ISSTRING(`area`) OR ISSTRING(`city`) ``` With no luck whatsoever...