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
On Wed, Mar 21, 2001 at 02:36:02PM +0100, Peter Szekszardi wrote:
> 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
Hi.
On Wed, 21 Mar 2001 14:36:02 +0100 (CET)
Peter Szekszardi <[EMAIL PROTECTED]> wrote:
> SELECT * FROM table WHERE title = NULL LIMIT 1;
SELECT * FROM table WHERE title IS NULL LIMIT 1;
http://www.mysql.com/doc/W/o/Working_with_NULL.html>
http://www.mysql.com/doc/P/r/Problems_with_NULL.html>
On Wed, 21 Mar 2001, Peter Szekszardi wrote:
> Date: Wed, 21 Mar 2001 14:36:02 +0100 (CET)
> From: Peter Szekszardi <[EMAIL PROTECTED]>
> 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 initia
use:
SELECT * FROM table WHERE title IS NULL LIMIT 1;
-Original Message-
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 7:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a text field (let's name it title).
Title will never be = NULL.
NULL is not equal to anything, not even NULL.
SELECT * FROM table WHERE title IS NULL LIMIT 1;
Peter Szekszardi wrote:
>
> 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 reco
Try checking the section 20.16 in the manual, it helped me.
That section is titled: Problems with NULL Values
But you could use:
SELECT * FROM table WHERE title IS NULL LIMIT 1;
/roger
> Hi,
>
> I have a database which has a text field (let's name it title). The field
> is NULL initially. Now
SELECT * FROM table WHERE title is NULL LIMIT 1;
Cal
http://www.calevans.com
-Original Message-
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 7:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a text fiel