This will list the non-numeric data values in a mysql column.
[cc lang=’sql’ ]select * from `tablename` where concat(”,`columnname` * 1) <> `columnname`[/cc]
Check for non-numeric data in mysql
Month: August 2011
Like my sticky notes on the web
Like my sticky notes on the web
This will list the non-numeric data values in a mysql column.
[cc lang=’sql’ ]select * from `tablename` where concat(”,`columnname` * 1) <> `columnname`[/cc]