query builder like with wildcard in the middle

The query builder works differently:

PHP Code:

$this->db->like('column', $alpha, 'both'); 
$query = $this->db->get('table');

if ($query->num_rows() > 0) {
   $records = $query->result();
}
else {
   $records = NULL;
}