MySQL rows deleted on varchar column

I have a situation where I am stuck. I want to delete all the records in a table of varchar column. The query is to be:

DELETE FROM table WHERE column = 'value'

But istead of this query I mistakenly executed the following query

DELETE FROM table WHERE column = 0

All the records in the table are deleted. Why? Any suggestion