Re: update combine values

Hi, try this : mysql> select * from usertable; +--+---++--+ | fullname | firstname | Middlename | lastname | +--+---++--+ | NULL | Scott | Junior | Tiger| +--+---++--+ 1 row

RE: update combine values

Ismet Dere 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