14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→is null
| Line 187: | Line 187: | ||
Find whether a variable is NOT NULL | Find whether a variable is NOT NULL | ||
* MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} | * MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} | ||
javascript | |||
* [http://www.w3schools.com/jsref/jsref_isnan.asp JavaScript isNaN() Function] | |||
=== check if field value was not fulfilled: NULL, empty value === | === check if field value was not fulfilled: NULL, empty value === | ||