How to make an sql query to select / check for matches from the current one in a string and do concat or update?

Question

MySQL

Good morning. Please tell me how can I implement this? Let's say find_in_set is looking for matches in a string. Concat combines them, I would go over the loop, but I don’t want to shit code.
Let's say there is a string in the base text1,text2,text3,text4
And there is an array [text1,text2,text3,text5]
How to make a query so that all matches are cut off and a new one is added, in the current example we want the following result:
text1,text2,text3 ,text4,text5