[dba-Tech] MySQL Syntax: Fresh eyes needed

Arthur Fuller fuller.artful at gmail.com
Sat Mar 16 07:35:56 CDT 2013


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


More information about the dba-Tech mailing list