chatgpt辅助编程

你可以使用CONCAT需要对其给出的建议进行评估和验证，避免盲目依赖。

函数将两个字段拼接起来。以下是修改后的SQL语句：

SELECT
    CONCAT(fi_order.Fthird_order_no, '-', fi_order.Fuser_name) AS '单号和客户名称',
    fi_order.Fuser_mobile AS '客户手机号',
    fi_order.Fuser_risk_level AS '客户风险等级',
    fi_order.Ffirst_verify_user_nickname AS '初审人员名称',
    fi_order.Ffirst_verify_advise AS '初审手输理由',
    fi_order.Dropdown_opinions AS '初审拒绝理由'
FROM
    fi_order
    LEFT JOIN review_comments_enum ON FIND_IN_SET(review_comments_enum.CODE, fi_order.Dropdown_opinions) > 0
WHERE
    fi_order.Dropdown_opinions LIKE BINARY '%a%'
GROUP BY
    fi_order.Dropdown_opinions;