'how to convert this query in codeigniter method chaing format

"SELECT invester_details.invester_name,invester_details.invester_contact,add_project.project_name, add_project.project_id FROM invester_details JOIN investment ON invester_details.invester_id=investment.invester_id JOIN add_project ON investment.project_id=add_project.project_id WHERE CONCAT(invester_name,invester_contact,project_name) LIKE '%$filtervalues%' AND add_project.project_id LIKE '$filtervalue'";



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source