I have encountered a weird problem in a MySQL query. This following query is returning me 0 result whereas there are many rows which should be returned. the query is
SELECT DISTINCT SKU, EAN, URL, CID FROM tab_comp_data WHERE status =''
And in many rows there are NULL values in STATUS column but it returns me no rows.
I have tried some other way round.
SELECT DISTINCT SKU, EAN, URL, CID FROM tab_comp_data WHERE status <>'INACT'
this also returns me no rows.
P.S. the STATUS column can only be