mysql - 在nodejs代码中使用带有WHERE子句的GROUP_CONCAT（）时mysql查询出错

Question

这是我的mysql查询字符串代码：

让查询字符串 = SELECT table1.*, group_concat(documents.url) as documentsUrl FROM table1 LEFT JOIN documents ON table1.Id = documents.table1_fk group by table1.Id;

    if (payload.searchString) {
        queryString += ` WHERE firstName LIKE '%${payload.searchString}%' OR lastName LIKE '%${payload.searchString}%'`;
    }
    if (payload.sortColumn) {
        queryString += ` ORDER BY ${payload.sortColumn} ${payload.sortOrder}`;
    }
    if (payload.page) {
        queryString += ` LIMIT ${offset}, ${payload.limit}`;
    }

标签： mysqlnode.js

Answer 1

通过...分组

SELECT 语句的子句应该在

在哪里

条款