The following query adds NAME and ADDRESS (where the last name is wrongly placed) and set ADDRESS to an empty string.
UPDATE tablename SET FullName=CONCAT(FullName,Address),Address='' WHERE ID=<the register id> Adolfo On Sat, 2002-12-21 at 17:07, Jim Hankins wrote: > Jeff, > > Are you looking for an update table syntax? > > Example > Update tablename > Set FullName="Their Full Name" where someotherfield="someother value"; > > Careful with this one. As if you omit the where clause it will update > every record! > > > > -----Original Message----- > From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 21, 2002 3:52 PM > To: [EMAIL PROTECTED] > Subject: MySQL Command to edit a single record > > Hi-- > > I have just begun using MySQL...I am using a program called MySQL to > manage > an online database. I can see the entire table I need and all the > records in > that table for the db Iım working with. I have a field called fullname > which > is supposed to receive the full name of the person entering the > information. > But sometimes, folks are entering their first name only in this field > and > then entering their last name in the address field by mistake. I would > like > to be able to send a command to the database to be able manually edit > those > records to add the last name back into the fullname field. > > Is there a way to do this? > > All My Best, > Jeffrey Ellis > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Adolfo Bello <[EMAIL PROTECTED]> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php