In my code, I query a table 'MYTABLE' and filter on the column 'STATUS <> -1'
$DB->get_recordset_select('mytable', 'status <> ?', array(-1));
I was very surprised that none of the records from the database where STATUS = NULL are returned.
Note: Definition on the field 'status'
install.xml : ...field name="status" type="int" length="1" notnull="false" sequence="false" ...
Question: Does it mean NULL = -1 in MySQL?
Please help me to understand this behaviour? is it correct or wrong?