Home » RDBMS Server » Server Administration » Select Where NULL - HELP
Select Where NULL - HELP [message #371355] Fri, 06 October 2000 05:13 Go to next message
Martin Johansson
Messages: 11
Registered: October 2000
Junior Member
Hi..

I want to do a select query where i get all rows where a specific column is NULL. I have tried the following:

SELECT * FROM mytable WHERE col1 = NULL;

but this doesn't return any rows. How do I write this correctly?

/Martin

Report message to a moderator

Re: Select Where NULL - HELP [message #371356 is a reply to message #371355] Fri, 06 October 2000 05:20 Go to previous message
Prem
Messages: 79
Registered: August 1998
Member
Martin,

use
SELECT * FROM mytable WHERE col1 IS NULL;

Prem :)

Report message to a moderator

Previous Topic: About Bfile
Next Topic: trigger not working
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 11:44:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.