[sql] Wyszukiwanie rekordow z NULLem Opcje

[Bojakki]

mam zapytanie:

[SQL] pobierz, plaintext 
$query = mysql_query("SELECT bb_building.id, bb_city.id FROM bb_building, bb_city WHERE bb_building.lo = NULL && bb_building.city = bb_city.id") OR die(mysql_error());
[SQL] pobierz, plaintext 

I nic mi nie wyszukuje mimo iz sa rekordy, ktore w tej komorce maja NULLa. Gdzie jest blad?

[Hazel]

[SQL] pobierz, plaintext 
SELECT bb_building.id, bb_city.id FROM bb_building, bb_city WHERE bb_building.lo IS NULL && bb_building.city = bb_city.id;
[SQL] pobierz, plaintext 

lub

[SQL] pobierz, plaintext 
SELECT bb_building.id, bb_city.id FROM bb_building, bb_city WHERE bb_building.lo = 'NULL' && bb_building.city = bb_city.id;
[SQL] pobierz, plaintext 

Ten post edytował Hazel 19.01.2008, 16:21:38