Select Mysql not return row when field is NULL and filter LIKE '%' : I have a table with a field:
 - field1 (Varchar(10)) Default NULL;

When I run this sql:
 - SELECT * FROM table WHERE field1 LIKE '%';

That query does not return rows where Field1 IS NULL;

Why NULL it is not considered as any value?

What solution do I have? I do not have to know the default value of the fields in a table to make a query.

Thanks.