14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→quick table
mNo edit summary |
|||
| Line 54: | Line 54: | ||
* method3: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name IS NULL</nowiki>}} | * method3: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name IS NULL</nowiki>}} | ||
* method4: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name IS NOT NULL</nowiki>}} | * method4: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name IS NOT NULL</nowiki>}} | ||
<table border="1" style="width: 100%"> | |||
<tr style="background-color: #555555; color: #ffffff;"> | |||
<td>data type</td> | |||
<td>possible values</td> | |||
<td>method5: <br />find values within the range</td> | |||
<td>method6: <br />find values out of the range, empty, NULL values</td> | |||
</tr> | |||
<tr> | |||
<td rowspan="4">{{kbd | key = VARCHAR}} or numeric</td> | |||
<td>values within the range ex: min ≤ value ≤ max</td> | |||
<td>V</td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>values out of range</td> | |||
<td></td> | |||
<td>V</td> | |||
</tr> | |||
<tr> | |||
<td>{{kbd | key = NULL}}</td> | |||
<td></td> | |||
<td>V</td> | |||
</tr> | |||
<tr> | |||
<td>EMPTY ex: <nowiki>'' or ' '</nowiki></td> | |||
<td></td> | |||
<td>V</td> | |||
</tr> | |||
</table> | |||
* method5: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE column_name BETWEEN min AND max</nowiki>}} | |||
* method6: {{kbd | key = <nowiki>SELECT * FROM `my_table` WHERE ( (COALESCE(column_name, '') = '') OR (column_name NOT BETWEEN min AND max) )</nowiki>}} | |||
== is null == | == is null == | ||