It is not supported directly through the like() helper, but you can do this:
$result = $this->db
->where('column like binary "abc"', NULL, FALSE)
->get('table')
->result();
An alternative method is:
$result = $this->db
->where('LOWER(column)', strtolower($foo), FALSE)
->get('table')
->result();
Notice I am using method chaining, it's a little quicker and to me is neater.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…