On Wed, 21 Mar 2001, Peter Szekszardi wrote:
> Date: Wed, 21 Mar 2001 14:36:02 +0100 (CET)
> From: Peter Szekszardi <szekszardi@stripped>
> 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;
I believe the syntax is not "title = NULL " but "title is NULL "
>
> 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-mussatto=csz.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
