MySQL 8.0

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

create table quiz ( answer text not null );
insert into quiz (answer) values
  ('Caffeine: Never'), ('Caffeine - Not much'), ('Caffeine:  No'), ('Caffeine-No');

Records: 4  Duplicates: 0  Warnings: 0

select regexp_replace(answer, '^Caffeine[^[:alnum:]]+', '')
from quiz;

regexp_replace(answer, '^Caffeine[^[:alnum:]]+', '')

Never

Not much

No

No