Multiple Keyword Search

[eluser]georgerobbo[/eluser]
Hello.

I have the following query which selects a profile from the database based on keyword/s. However, the problem I am having is if you search for either a first name or surname of a user the database returns relevant results. However if you use both the first name and surname in the query the database returns zero results.

How can I adjust my model so?

Code:

function search($keyword)
    {
        $this->db->select('*');
        $this->db->from('member');
        $this->db->like('ID', $keyword);
        $this->db->or_like('Firstname', $keyword);
        $this->db->or_like('Surname', $keyword);
        $this->db->group_by('ID');
        
        $query = $this->db->get();
        return $query->result_array();
    }