mysql, case sensitive compare through codeigniter

codeigniter

Solution

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.

Problem

I wanted to write following query through codeigniter's db helper class, guide me plz ``` SELECT * FROM table where column like binary "abc"; ``` I tried ``` $this->db->select("*"); $this->db->from("table"); $this->db->like("column","binary abc"); $this->db->get(); ``` but it produces ``` SELECT * FROM table WHERE column like '%binary abc%' ```

Original source