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: Thursd
Michael
--Original Message-
> 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 diff
On 18 September, 2003 11:56, Michael Piko [SMTP:[EMAIL PROTECTED] wrote:
> I am trying to select the firstname and surname fields from a table.
>
> select firstname + surname fullname from people;
>
try:
select concat(firstname,surname) as fullname from people;
HTH,
Mark
-
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 Gen
