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]

Reply via email to