you should use replace () function

Hallo and thank you for your reply.
I've read about this replace function, but I didn't get how I am supposed to use it in an update query.

Is it necessary to use in the update query. You can use it directly as well and change the strings.

Is you string '<i>"*"</i> residing in a particular column or it is in any column?

you might use this
update table_name=
set colum_nmae = REPLACE('abcdefghicde','cde','#*$!');

output
ab#*$!fghi#*$!

Hallo!

Now I got the main idea. Thanks.
I have a field in which <i> </i> can be contained.
But I'd like that the text of the field is the 1st argument of replace.
Something like:

update myTable = set myField = REPLACE(SELECT note FROM canzoni,'<i>','');

Of course that doens't work.
With PHP I could do:

$ptr = mysql_query("SELECT myField, id FROM myTable");

// ...inside the reading loop with $myArr the array that stores DB data
mysql_query("UPDATE myTable = set myField = REPLACE($myArr[0], '<i>', '') WHERE id=$myArr[1]");
mysql_query("UPDATE myTable = set myField = REPLACE($myArr[0], '</i>', '') WHERE id=$myArr[1]");

But I'd prefer to write a single query once and for all. Is that possible?

Thanks!

I actually did not get you question.

If possible please ellaborate for more understanding. An example would be better to understand.