If you use MySQL 8.0 or later, you can use to view CHECK CONSTRAINTS:

SELECT * FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS WHERE CONSTRAINT_SCHEMA = 'your_db_name';