Peter,
try
SELECT * FROM table WHERE title IS NULL LIMIT 1;
HTH,
Christopher Oson
-----Original Message-----
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 5:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a text field (let's name it title). The field
is NULL initially. Now I have about a hundred thousand records in the db,
where the title field is NULL. I have to fill these NULL title fields with
the appropriate data, so I have to select them one-by-one, calculate the
title field, and update the data. So my query would be:
SELECT * FROM table WHERE title = NULL LIMIT 1;
But it does not work. One of you wrote, that NULL is not equal with
anything, not even with NULL. Could you please help me, what kind of
select should I write in situations like this? In this particular case, I
will do find a workaround, but I am curious, how to handle NULL values.
Regards,
Peter Szekszardi
PortoLogic Ltd.
Portal building, prime number generating, script hacking and more...
The prime number of the day is 262559183
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
