语法错误，意外'FIND_IN_SET'（T_STRING）[关闭]

Question

I am using FIND_IN_SET in where condition in Codeigniter, and I am facing the following error:

syntax error, unexpected 'FIND_IN_SET' (T_STRING)

How to solve it??

My model is the following:

function getTask($id, $is_master_admin) 
{
    $this->db->select('task.*, workspace.title as workspacetitle, GROUP_CONCAT(user.title ) AS usertitle,task.assigneduserid,user,id',FALSE);
    $this->db->join(WORKSPACE , WORKSPACE . '.id = ' . TASK . '.workspaceid', 'inner');
    $this->db->join(USER,USER . '.id = ' . TASK . '.assigneduserid', 'inner');
    $this->db->from(TASK);
    $this->db->group_by("task.id");         
    if (!$is_master_admin) {
        $this->db->where FIND_IN_SET($id,"task.assigneduserid");
    }

    $this->db->where(TASK . '.tasktypeid', '1');
    if ($query->num_rows() > 0) {
        return $query->result();
    } else {
        return false;
    }
}

Please help me to solve this, thank you.

Answer 1

$this->db->where FIND_IN_SET($id,"task.assigneduserid");

to

$this->db->where("FIND_IN_SET($id, task.assigneduserid)");

you forgot to open paranthesis.