php - jquery数据表中的Group Concat方法

Question

我已经添加了 jquery 数据表并发出了 ajax 请求。在服务器端，我正在使用表的连接。数据表完美加载，但搜索过滤器无法正常工作。搜索 ajax 调用时显示未找到列“screen”，这是真的，因为它在数据库中不存在。我该如何解决这个问题？

 $data = self::sql_exec( $db, $bindings,

            "select r.title,group_concat(distinct n.name) as screens, group_concat(na.action) as permissions "."
             FROM `$table` as r
             left JOIN permissions p on p.role_id = r.id
             left join `navigations` n on n.id = p.nav_id 
            left join `navigation_actions` na on na.id = p.action_id 
             $where
             group by r.id
             $order
             $limit
             "
        );

Answer 1

一个解决方案是在此语句之上添加另一个 select 语句。

示例(在 mysql 中):

SELECT * FROM (

       "select r.title,group_concat(distinct n.name) as screens, group_concat(na.action) as permissions "."
             FROM `$table` as r
             left JOIN permissions p on p.role_id = r.id
             left join `navigations` n on n.id = p.nav_id 
            left join `navigation_actions` na on na.id = p.action_id 
             $where
             group by r.id
             $order
             $limit
         "
) AS my_table WHERE screens = "your_query_data"