;[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
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
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
