14,971
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→is null
mNo edit summary |
|||
| Line 10: | Line 10: | ||
Finds whether a variable is NOT NULL | Finds whether a variable is NOT NULL | ||
* MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} [http://sqlfiddle.com/#!2/ec1152/2/0 demo] | * MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} [http://sqlfiddle.com/#!2/ec1152/2/0 demo] | ||
== check if field value was not fulfilled: NULL, empty value == | |||
# {{kbd | key = NULL}} value: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL;}} | |||
# empty value: {{kbd | key = SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) = 0;}} | |||
== check if field contains value == | |||
(left blank intentionally) | |||
== references == | == references == | ||