Deleting an entire entry of data?

[Freedom-n-Democrazy]

I have this table:

+------+---------------+------------+

| id | primarycolour | pricerange |

+------+---------------+------------+

| 1 | black | 1 |

| NULL | brown | 2 |

+------+---------------+------------+

 

I want to delete the entire entry for NULL. I tried this, but it didn't work:

delete from testdb.products where id='NULL';

 

How can it be done?

 

Also, I don't think saying "deleting an entire entry of data" is correct. Is what I am asking to do is to delete a primary key?

[Muddy_Funster]

close, but by using ='NULL' you are saying "where the field contains a thext string 'NULL'

what you need is

delete from testdb.products where id IS NULL;