如何在codeigniter查询中使用FIND_IN_SET？

Question

$array = array('classesID' => 6);
$this->db->select()->from($this->_table_name)->where($array)->order_by($this->_order_by);
$query = $this->db->get();
return $query->result();

I need to get the rows where the classesID is 6. Some rows contain 6,5,4. so i need to use FIND_IN_SET query to retrive where the classesID is 6.

Please guide me

Thanks

Answer 1

You can write the query like this.

return $this->db->where('classesID' , '6')->order_by('column_name','desc')->get('table_name')->result_array();

if Need any help comment