List:General Discussion« Previous MessageNext Message »
From:Cal Evans Date:March 21 2001 4:28pm
Subject:RE: selecting null values
View as plain text  
SELECT * FROM table WHERE title is NULL LIMIT 1;


Cal
http://www.calevans.com
 

-----Original Message-----
From: Peter Szekszardi [mailto:szekszardi@stripped]
Sent: Wednesday, March 21, 2001 7:36 AM
To: mysql@stripped
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 <mysql-thread69019@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-cal=calevans.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
query with <> or !=Gilles Dumangin20 Mar
  • Re: query with <> or !=Sinisa Milivojevic20 Mar
  • selecting null valuesPeter Szekszardi21 Mar
    • RE: selecting null valuesCal Evans21 Mar
    • Re: selecting null valuesroger westin21 Mar
    • Re: selecting null valuesGerald L. Clark21 Mar
    • Re: selecting null valuesWilliam R. Mussatto21 Mar
    • Re: selecting null valuesChihiro Hio21 Mar
    • Re: selecting null valuesPaul DuBois21 Mar
RE: selecting null valuesRick Emery21 Mar
RE: selecting null valuesChris M. Oson21 Mar