Auto adding the IS NULL in FIND_IN_SET 100% solved
You need to add !=0
is your where clause
to remove IS NULL
$this->db->select('id,name,category,sent_by,read_by,date');
$this->db->from('name');
$this->db->where("FIND_IN_SET('1',`category`) !=", 0);
$this->db->order_by('`id`','DESC');
$this->db->get();