UPDATE question

[Cummings, Shawn (GNAPs)]

If I have 4 Fields (FIELD1, FIELD2, FIELD3 & FIELD4)....
I can do this easily;

UPDATE TABLE_NAME SET FIELD4 = FIELD1;

But -- how do I do it so that FIELD4 = FIELD1 & FIELD2 ???  I can't seem 
to find any examples online.  Maybe it's just too early in the morning - 
I'm drawing a blank! ;)






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]