tags:

views:

17

answers:

2

I added a column to my table that does not allow null. I guess that is why some of my rows now have real values in the column but some other rows now have (err) in the column. How can I query for this?

select * from Table where new_column = err

That doesn't work.

A: 

select * from Table where new_column is null I think this will work, but my MySQL skills are rusty

andrewWinn
No, that will not work because they are not actual nulls. The column does not allow nulls.
erotsppa
+1  A: 

select * from Table where new_column='err'

KM
No, that will not work because they are not actual nulls. The column does not allow nulls
erotsppa