CodeIgniter Like Query Example

In the codeigniter framework, we have to use the function $this->db->like(); to generate the LIKE clause. It should be used along with codeigniter select query to automatically generate where and like operators.

Take this mysql table 'student' as an example.

This like query in codeigniter searches the table 'student' for the records having the substring 'sili' in the column 'StudentName'.

$this->db->select('*');

$this->db->from('Books');

$this->db->like('BookName', 'Power');

$query = $this->db->get();


// Produces SQL:

// SELECT * FROM Books WHERE BookName LIKE '%Power%';

Query Result: