| MySQL

Home

NULL

There is a table "Persons":

P_Id	LastName	FirstName	Address	City
1	Hansen	Ola		Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes
3	Pettersen	Kari		Stavanger

Query Result:

LastName	FirstName	Address
Hansen	Ola
Pettersen	Kari

Note -

1 2	SELECT LastName,FirstName,Address FROM Persons WHERE Address NULL

Query Result:

LastName	FirstName	Address
Svendson	Tove	Borgvn 23

+13 #1 student 2010-08-20 02:22 there mistake! you want to show records where the value is not NULL, and write in the query text is NULL! Quote

Address	Dmitry Kupriyanov Kramatorsk Ukraine
E-mail	ageent.ua @ gmail.com ageent.ru @ gmail.com
Phone	Mobile: +380 54 501 90 28 Home: +380 626 44 10 998
Websites	www.ageent.ru