Assuming that the address field is of type char or varchar, Assuming that the address field has a NULL default value the following should do it
select ... from ... wehre address is null; In case that the address field has no default value the following should do it: select ... from ... where address=''; If one or more of my assumptions are wrong PLS provide us with the structure of your table with "describe tables ..." Bernard On Tuesday 17 February 2004 14:16, Caroline Jen wrote: > Please help. What is the syntax of idenfying those > who "do not" have addresses (in the address field) in > the database? > > __________________________________ > Do you Yahoo!? > Yahoo! Finance: Get your refund fast by filing online. > http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]