Data cleaning: Difference between revisions

Data cleaning (edit)

134 bytes added , 12 May 2016

14,962

edits

@@ Line 255: / Line 255: @@
 === numeric only ===
 * PHP: [http://php.net/manual/en/function.is-numeric.php is_numeric]
-* MySQL: {{code | code = SELECT * FROM `my_table` WHERE `my_column` REGEXP '^[0-9]+$'}}<ref>[http://stackoverflow.com/questions/14343767/mysql-regexp-with-and-numbers-only regex - Mysql REGEXP with . and numbers only - Stack Overflow]</ref>
+* MySQL:
+** find numeric values {{code | code = SELECT * FROM `my_table` WHERE `my_column` REGEXP '^[0-9]+$'}}<ref>[http://stackoverflow.com/questions/14343767/mysql-regexp-with-and-numbers-only regex - Mysql REGEXP with . and numbers only - Stack Overflow]</ref>
+** find NOT numeric values {{code | code = SELECT * FROM `my_table` WHERE `my_column` NOT REGEXP '^[0-9]+$'}}
 * Excel: [http://www.techonthenet.com/excel/formulas/isnumber.php ISNUMBER Function]