How come this one works:
SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new,
FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id =
wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac
WHERE last_seen >= CURRENT_DATE AND wifi_list IS NULL;
This one works too
SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new,
FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id =
wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac
WHERE last_seen >= CURRENT_DATE HAVING wifi_list_new IN (0,1,2);
But this one doesn't... I *need* this to work:
SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new,
FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id =
wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac
WHERE last_seen >= CURRENT_DATE AND wifi_list IN (NULL);
mysql Ver 12.22 Distrib 4.0.16, for pc-linux (i686)
