2 messages in com.mysql.lists.mysqlRe: sql syntax
FromSent OnAttachments
Marlon17 Oct 2003 10:53 
Chris Boget17 Oct 2003 11:07 
Subject:Re: sql syntax
From:Chris Boget (chr@wild.net)
Date:10/17/2003 11:07:46 AM
List:com.mysql.lists.mysql

Hello, my name's Marlon. I have a question about sql and I need some help! How can I do something like it using mysql? update registre set (name='NewName' where lastname='OldLastName'), (name='OldName' where lastname='NewLastName');

I _believe_ you can do it this way. I'm sure someone will correct me if I am mistaken:

UPDATE registare SET CASE lastname WHEN 'OldLastName' THEN name = 'NewName' WHEN 'NewLastName' THEN name = 'OldName' END;

Chris