开发者

How to query for err in MySQL?

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.


select * from Table where new_column='err'


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜