Let's say I want to run a query that will replace the word dog with cat in all records. How could I accomplish that?
I know worst case scenario, I could just loop through each record, run str_replace() on it, then update the record with the new text, but I'm hoping there's an easier way? :confused:
