How to delete all lines from a CSV file containing an exact match of a search term?

I have a CSV file like this:

text,0
 more text,2
 some more text,100
 

I need to delete any line containing only 0 in the second column, e.g., the output of the above would be:

more text,2
 some more text,100
 

How can I delete all lines from a CSV with an exact match?

---