retrieve a user whose one column field is blank

How to retrieve the detail of a student who开发者_Python百科se course column field is blank?

How can this be done with a query?

---

SELECT *
FROM Student
WHERE course = ''
OR course IS NULL

---

It's not clear from the question whether a null entry qualifies a row as part of the resultset.

Try this:

SELECT * From Student 
WHERE Course = '' 
OR Course IS NULL  --remove/keep this depending on your need for null checking