Snippet Name: Select based on a field that can have a NULL value Description: This is an example of a SELECT statement based on a field that can have a NULL value. Comment: (none) Language: MYSQL Highlight Mode: MYSQL Last Modified: March 01st, 2009
Description: This is an example of a SELECT statement based on a field that can have a NULL value.
SELECT * FROM TABLE WHERE NOT ISNULL(COLUMN)