14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→check if field value was fulfilled
| Line 39: | Line 39: | ||
check numeric range | check numeric range | ||
* MySQL: {{kbd | key = SELECT * FROM table_name WHERE column_name BETWEEN ''min_number'' AND ''max_number'';}} the value >= ''min_number'' AND value <= ''max_number'' | * MySQL: {{kbd | key = SELECT * FROM table_name WHERE column_name BETWEEN ''min_number'' AND ''max_number'';}} the value >= ''min_number'' AND value <= ''max_number'' ( ''min_number'' ≤ value ≤ ''max_number'' ) | ||
== verify the format of field value == | == verify the format of field value == | ||