Piko, Please see http://www.mysql.com/doc/en/String_functions.html for more information about String functions in the SELECT. The function you're looking for is CONCAT or CONCAT_WS.
Harald ----- Original Message ----- From: "Michael Piko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 18, 2003 11:55 AM Subject: combining fields in select > I am trying to select the firstname and surname fields from a table. > > select firstname + surname fullname from people; > > This does work in other databases but does not seem to work here. > > Am I doing something wrong or is there a different way to achieve this with mysql? > > Michael > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
