Mysql help

does anyone know how to modify / change existing text in a db (replace
func.) ?
something like -

========DB========

table foods
column fruit
row 1
“we really need to bring apples and fruit”
row 2
“we really need to bring oranges and mangos”
row 2
“we really need to bring apricots”

=======end result needed======

table foods
column fruit
row 1
“we need to bring apples and fruit”
row 2
“we need to bring oranges and mangos”
row 2
“we need to bring apricots”

=========================

it would be something along the lines of the code below, but this only
modifies the text shown at the end program; i need the text modified IN
the db.

@foods = Food.find(:all)
food_rows = @foods.collect(&:fruit)
food_rows.each |r|
r.gsub(“really”, “”)
end

any help? many thanks for any tips.

shai

cancel this thread, i hope i’ve posted a clearer question (above this
post) thx

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs