14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→check if field contains value
| Line 30: | Line 30: | ||
== check if field contains value == | == check if field contains value == | ||
length of string > 0 | length of string > 0 | ||
* MySQL: {{kbd | key = SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) != 0;}} [http://sqlfiddle.com/#!9/e0e5f/1/0 demo] | * MySQL: {{kbd | key = SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) != 0;}} [http://sqlfiddle.com/#!9/e0e5f/1/0 demo][http://ideone.com/rt6D2A] | ||
column value is not {{kbd | key = null}} or {{kbd | key = 0}} | column value is not {{kbd | key = null}} or {{kbd | key = 0}} | ||