如何在mysql-ajax表编辑器中使用IN运算符


How to work with IN operator in mysql ajax table editor

我在mysql中创建了一个查询,它是:

select 
address,state,id 
from
addressdata 
where
address in (select address from addressdata group by address having count(*) > 1)

但我面临着一个问题:如何在MysqlAjax表编辑器中实现查询?

我在mysql-ajax表编辑器中以以下方式定义了列:

function initiateEditor()
{
    $tableColumns['ID'] = array(
        'display_text' => 'ID', 
        'perms' => 'VT', 
    );
    $tableColumns['State'] = array(
        'display_text' => 'State', 
        'perms' => 'VT', 
    );
    $tableColumns['Address'] = array(
        'display_text' => 'Address', 
        'perms' => 'VT', 
        'table_fun' => array(&$this,'formatLink'), 
        'view_fun' => array(&$this,'formatLink')
    );
}
function formatLink($col,$val,$row) 
{ 
    $query1=mysql_query("select Address from addressdata group by Address having count(*) > 1") or die(mysql_error());
}

但这似乎不像正常的查询那样工作,请帮助解决这个问题。

嗨,使用这样的东西,它可能对你的有用

$this->Editor->setConfig('sqlFilters',"Address != '' and Address IN(select address from addressdata group by address having count(*) > 1)");