mysql - SQL 内联 IF 语句显示列名和字符串

Question

我正在尝试在 SQL 中运行 IF 语句:

IF(customer = 'Y', contact_name + '(' + contact_email + ')', 'Internal')

该语句适用于其正确和错误，但我希望能够显示

contact_name(表格列)

然后在旁边的括号中，它将显示 contact_email，这也是一个表格列。

我在使用 contact_email 周围的括号时遇到问题。

我的完整查询是:

SELECT datetime as datetime, notes as notes 
FROM customer_communication 
WHERE company = '276' 
UNION ALL 
SELECT datetime as datetime, 
       CONCAT('Ticket #', + ticketnumber, + 
              ' () Opened By ', + 
              IF(customer = 'Y', contact_name '(' contact_email ')', 
                                 'Internal')) as notes 
FROM tickets 
WHERE company = '276'

我看到这个错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''(' contact_email ')', 'Internal')) as notes FROM tickets WHERE company = '276' ' at line 1

Answer 1

这应该有效:

SELECT datetime as datetime, notes as notes 
FROM customer_communication 
WHERE company = '276' 

UNION ALL 

SELECT datetime as datetime, 
       CONCAT('Ticket #', 
              ticketnumber, 
              ' () Opened By ', 
              IF(customer = 'Y', contact_name + '(' + contact_email + ')'
                               , 'Internal')) as notes 
FROM tickets 
WHERE company = '276'