selecting null values

2001-03-21 Thread Peter Szekszardi
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

RE: selecting null values

2001-03-21 Thread Cal Evans
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

Re: selecting null values

2001-03-21 Thread roger westin
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 I

Re: selecting null values

2001-03-21 Thread Gerald L. Clark
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 records

RE: selecting null values

2001-03-21 Thread Rick Emery
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

Re: selecting null values

2001-03-21 Thread William R. Mussatto
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 initially. Now I

Re: selecting null values

2001-03-21 Thread Chihiro Hio
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; URL:http://www.mysql.com/doc/W/o/Working_with_NULL.html

Re: selecting null values

2001-03-21 Thread Paul DuBois
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

RE: selecting null values

2001-03-21 Thread Oson, Chris M.
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