Select Query Limit in Codeigniter

[ravi142]

Hello

I have use 'LIKE' query in Model

$this->db->like('job_title','keywords','both');
$query = $this->db->get('job_description',$data);

which generate Query Output like

SELECT *
FROM (`job_description`)
WHERE  `job_title`  LIKE '%keywords%'
LIMIT 1  

Problem: How could i remove the LIMIT that automatic generate in Query OR can i given Infinite LIMIT in CI Query.

Can you Suggest me..

Thank You.

[catalinetu]

Hello,

Try this:

$query = $this->db->get('mytable', 10, 20);

// Produces: SELECT * FROM mytable LIMIT 20, 10 (in MySQL. Other databases have slightly different syntax)

or this

$query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset);

[veedeoo]

catalinetu is correct, just add second and third parameter to the get method. Derived from this

public function get($table = '', $limit = null, $offset = null)
{

}