result from autocomplete with ajax jquery json is not exactly

[eluser]john_j[/eluser]
in your model, after this line $query = $this->db->get(); add this new line which is
echo $this->db->last_query(); exit; and run the code. This will display the sql. Run this sql on your database and decide if the sql query that you are using is correct.