updating a string in database..?

hola, wondering if this is possible,

id like to update only a part of my table info,

ie. if my table contained

texttexttexttexttext texttexttexttext bananna text text text

could I update where string = bananna to apple

and the result would look somthing like

texttexttexttexttext texttexttexttext apple text text text

not sure if this is possible,

thanks

For the where clause, I think you can get away with WHERE field like "%banana%" or WHERE LOCATE(field, "banana") > 0

Then for the SET clause I think you could do: SET field = REPLACE(field, "banana", "apple")

This is assuming you're on MySQL.

aye, mySQL,
thanks!