MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE students (
  enroll_id VARCHAR(20) PRIMARY KEY,
  std_name VARCHAR(24),
  CONSTRAINT valid_enroll_id CHECK (enroll_id REGEXP '^20[0-9]{2}(CS|EC|MC|CV)[0-9]{3}(D|0)[0-9]{3}$')
);
select * from students;


enroll_id
std_name


insert into students values('ABC123', 'ABCDEF');

Check constraint 'valid_enroll_id' is violated.


insert into students values('2021CS213D011', 'ABCDEF');
select * from students;


enroll_id
std_name


2021CS213D011
ABCDEF