[dba-Tech] MySQL Syntax: Fresh eyes needed

OR does it need brackets like [Last Name]?

R
 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Saturday, March 16, 2013 6:51 AM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] MySQL Syntax: Fresh eyes needed

Try 'customers.Last Name' instead of customers.`Last Name' etc

--
Stuart

On 16 Mar 2013 at 8:35, Arthur Fuller wrote:

> I've been staring at this expression too long and my eyes are 
> beginning to
> cross:
> <,mysql>
> SELECT
> IF(ISNULL(customers.`Last 
> Name`),customers.Company,CONCAT(customers.'First
> Name',' ', customers.'Last Name')) as 'File As:'
> from `customers`
> </mysql>
> 
> Syntax error. The Concat() part works fine in isolation so the problem 
> is not there
> 
> TIA,
> Arthur
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 


_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com