sql - Updating/changing a specific portion of a string in mysql? -

I have tried a few different ways to do this, and all the errors return. So in this exact situation, I am trying to change some place in disturbance with someone else. In this case, this is a Playloadel. And I'm using mysql pointshop I especially want to change the word "Ironman" with "vector" in the items row. These are different ones that I've tried to do:

  UPDATE `pointshop_data` SET` item` = empty (` item`, 'ironman', 'vector')  

and

  updateto_data SET item = spaces (items, 'ironman', 'vector') where items are like '% ironman%';  

Both came from here:

I have tried that I get a single syntax error in any different way:

It seems that I do not remember the smallest thing here, but I did exactly as the answer given in the second question.

Try the following questions:

  update 'pointHop_Data' SET Item = replay (item, 'ironman', 'vector') where items are like '% ironman%';