Results 1 to 12 of 12

Thread: [Resolved] SQL Update/Replace Help

Threaded View

  1. #1

    Thread Starter
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256

    [Resolved] SQL Update/Replace Help

    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?
    Last edited by The Hobo; Aug 3rd, 2003 at 02:42 PM.
    My evil laugh has a squeak in it.

    kristopherwilson.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width