Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→Verify the format of field value
| Line 234: | Line 234: | ||
* MySQL: {{kbd | key =<nowiki>SELECT * FROM table_name WHERE column_name != '' AND column_name IS NOT NULL;</nowiki>}} | * MySQL: {{kbd | key =<nowiki>SELECT * FROM table_name WHERE column_name != '' AND column_name IS NOT NULL;</nowiki>}} | ||
== | == Data Validation == | ||
Validate the format of field value. Related page: [[Regular expression]] | |||
=== Email contains @ symbol === | === Email contains @ symbol === | ||