I am trying to select rows from a mysql table where some fields are empty but it returns nothing. Say I have a string field in my table which is empty, the following query doesn't work as expected: SELECT * FROM myTable WHERE `Field1`='' PHP: How do I resolve it?
The field may also be null so do something like SELECT * FROM myTable WHERE `Field1`='' or `Field1`is null Code (sql):