Ismet Dere <mailto:[EMAIL PROTECTED]> wrote:
> my question is that, is it possible to combine values of multiple > fields in another field of same table with an update statement such > as this; > > UPDATE UserTable SET FullName = FirstName & MiddleName & LastName; UPDATE UserTable SET FullName = CONCAT(IFNULL(CONCAT(FirstName, ' '), ''), IFNULL(CONCAT(MiddleName, ' '), ''), IFNULL(LastName,'')); Peter Normann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
