How to make MySQL unique field with exception?

Question

MySQL

Good day.
There is a table:

id| name
0 | Book
0 | Video
11| Game
12| Movie
13| Story

How to make the ID field unique but with an exception that 0can be repeated?

Answer 1

If id is the primary key, then no way.
If just a unique field, then use NULL instead of zero.