How to make a specific update command in sql?

Question

MariaDB

Site on the dle engine, you need to upload the category number in the additional field using the sql command. That is, in the category cell, for example, such a situation 9,10,11,12 is all news categories in the dle_post table. It is necessary to transfer the number 9 to an additional field called tema.
I understand there is some kind of update command here. And the LIKE '%9,% attribute comes in handy. Help shape it.

Answer 1

Form the question correctly.
This?

Update name_table Set field_tema = field_tema + "9" Where categoty in (9,10,11,12)