[Resolved] date field checking

[chintupintu03]

Hi all,

In one of my database tables, there is a field with date type. It is not a mandatory field, so while adding a record, record may contain value as "0000-00-00".

If I have to find out how many records are with above mentioned date.

What can be the query ?

[rebelo]

This isn't a php coding question, so this isn't the correct forum, but the answer is:

SELECT * FROM table WHERE date='0000-00-00'