数据库 |将 CONCAT 函数格式化为带有小括号

Question

我在查询中选择了

IFNULL(GROUP_CONCAT(DISTINCT CONCAT(ED.dependent_name, ED.date_of_birth))," No Dependents ") AS Dependents

我得到的结果是这样的..

数据很好，但问题是，它看起来不整洁，我想在括号中加上出生日期例如，对于员工 E-02，我想记录这样的内容，意思是将日期括在小括号中。

Muhammad Zubair (1998-12-15) ,Amir Khan (2000-12-15)

有什么方法可以更新上面的 select 语句并获得我想要的结果或任何其他更好的方法来获得好看的结果。？

我的查询:

SELECT 
  `E`.`employee_code` AS Employee_Code,
  E.full_name AS NAME,
  E.father_name AS Father_Name,
  IFNULL(
    GROUP_CONCAT(
      DISTINCT CONCAT( ED.dependent_name '(', ED.date_of_birth, ')')), " No Dependents " ) AS Dependents 
FROM
  (`employee` E) 
  INNER JOIN `employee_project` EP 
    ON `EP`.`employee_id` = `E`.`employee_id` 
  INNER JOIN `permanant_contacts` PC 
    ON `PC`.`employee_id` = `E`.`employee_id` 
  INNER JOIN `ml_district` MLD 
    ON `MLD`.`district_id` = `PC`.`district` 
  LEFT JOIN `dependents` ED 
    ON `ED`.`employee_id` = `E`.`employee_id` 
    AND ED.trashed = 0 
WHERE `E`.`trashed` = 0 
GROUP BY `E`.`employee_id` 

Answer 1

你试过吗

CONCAT(ED.dependent_name, '(', ED.date_of_birth, ')')