#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    hi, i'm new to mysql. i need to find out the command to replace the string "Jake" with "NiHiLiST" in the 'Author' field of the table 'news' in the database 'translucency'. or i need an example with some sample names. i think u guys r the best to ask, cos u seem to know everything else.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    update news set author='NiHiLiST' where author='Jake';

Similar Threads

  1. Replies: 1
    Last Post: November 24th, 2003, 07:46 PM
  2. Finding and Replacing Strings in a File
    By Outrager in forum C Programming
    Replies: 1
    Last Post: October 19th, 2003, 08:00 AM
  3. replacing strings
    By BooDog in forum HTML Programming
    Replies: 12
    Last Post: February 4th, 2002, 06:50 PM
  4. Replacing partial strings in MYSQL Fields
    By Denzel in forum MySQL Help
    Replies: 1
    Last Post: March 2nd, 2001, 01:07 PM
  5. Replacing strings with dynamic content.
    By Michael_Bray in forum PHP Development
    Replies: 2
    Last Post: October 27th, 2000, 05:43 AM

IMN logo majestic logo threadwatch logo seochat tools logo