Try :
SELECT * From table WHERE `address` = ''
Or
SELECT * From table WHERE `address` IS NULL
-Ursprüngliche Nachricht-
Von: Caroline Jen [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Februar 2004 20:17
An: [EMAIL PROTECTED]
Betreff: How To Write This SQL Statement
P
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
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 li
