Hi, try this : mysql> select * from usertable; +----------+-----------+------------+----------+ | fullname | firstname | Middlename | lastname | +----------+-----------+------------+----------+ | NULL | Scott | Junior | Tiger | +----------+-----------+------------+----------+ 1 row in set (0.00 sec)
mysql> UPDATE UserTable SET FullName = concat(FirstName,' ',MiddleName, ' ',LastName); Query OK, 1 row affected (0.19 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from usertable; +--------------------+-----------+------------+----------+ | fullname | firstname | Middlename | lastname | +--------------------+-----------+------------+----------+ | Scott Junior Tiger | Scott | Junior | Tiger | +--------------------+-----------+------------+----------+ 1 row in set (0.00 sec) You can also define the separator once using concat_WS. see http://dev.mysql.com/doc/mysql/en/string-functions.html for more details. Mathias Selon Ismet Dere <[EMAIL PROTECTED]>: > Hi am fairly new to mysql and need some help, i have search thru online > documents but found not much help to this. > > 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; > > i appreciate any help, thanks > > ismet > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
