NULLs

NULL means "no data".

NULL is case-insensitive. \N is case-sensitive and is a synonym of NULL. Note that a NULL is different from the number 0 and the empty string ''.

When you execute the ORDER BY statement to sort data, NULLs come before other values in an ascending sort, or after other values in a descending sort.