使用 group_start 进行 MySQL 查询 - CodeIgniter Active Record

Question

我想将当前的 MySQL 查询更改为 Active Record。

 SELECT * FROM search_result
 WHERE experience 
 LIKE 'hello%' OR
 bio LIKE 'hello%' OR 
 FIND_IN_SET('3D Design',skills);  

我尝试了以下查询，但它显示错误的输出。

$this->db->from('search_result');
if($keyword){
    $this->db->like('experience', $keyword);
    $this->db->or_like('bio', $keyword);
}elseif($s_id){
    $this->db->where("FIND_IN_SET('$s_id[0]', skills) != ", 0);
    for($x=1; $x < count($s_id); $x++) {
        $this->db->or_where("FIND_IN_SET('$s_id[$x]', skills) != ", 0);
    }
}
............
$query = $this->db->get();
return $query->result_array();

Answer 1

你是这个意思吗

$this->db->from('search_result');
$this->db->where("experience LIKE 'hello%' 
                  OR bio LIKE 'hello%'
                  OR  FIND_IN_SET('3D Design',skills)");