在codeigniter中分页时使用带有where条件的REGEXP

$this->load->library('pagination');
$this->load->database();

$config['base_url'] = 'http://example.com/controller/method';
$config['total_rows'] = $this->db->count_all('your_table');
$config['per_page'] = 10;
$config['uri_segment'] = 3;

$where_condition = "your_column REGEXP 'your_pattern'";

$this->db->select('*');
$this->db->from('your_table');
$this->db->where($where_condition);
$this->db->limit($config['per_page'], $this->uri->segment(3));
$query = $this->db->get();
$result = $query->result();

$data['result'] = $result;
$this->load->view('your_view', $data);

foreach ($result as $row) {
    // 显示数据
}