Selecting Entries With Blank Column in MYSQL


Selecting Entries With Blank Columns in MYSQL

Objective: Select all rows in a table for which there are blank values. You may want to see the values before you delete all the entries with a specified blank column.

To select entries with an empty column,
1) SELECT * FROM tablename WHERE column_name='';