[dba-Tech] MySQL Syntax: Fresh eyes needed

D*mn, that's what you get posting at this time in the morning.

For "backquotes", read "square brackets".

On 17 Mar 2013 at 0:48, Stuart McLachlan wrote:

> MySQL doesn't do backquotes. 
> 
> Peter is probably right - I didn't pick that they were single quotes and not backticks.
> 
> -- 
> Stuart
> 
> On 16 Mar 2013 at 7:43, Rocky Smolin wrote:
> 
> > 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
> > 
> > _______________________________________________
> > 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
>