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