Of course, the design is ugly and needs to be changed, but for the matter of removing part of the strings ther's no need to mess with INSTR and SUBSTR. There is a function REPLACE provided that does exactly what is needed here:

UPDATE restaurant SET cusine_type = REPLACE(cusine_type, ',2,', ',');