codeigniter $this->db->like is case sensitive - Stack Of Codes

Breaking

Ads

Monday 12 February 2018

codeigniter $this->db->like is case sensitive

There is no case insensitive version of the like function. What you can do is transform both sides of the comparison to lower case, so that you take that out of the equation.

$this->db->like('LOWER(' .$field. ')', strtolower($value));

OR
$this->db->like('LOWER(field_name)', strtolower($value));

No comments:

Post a Comment

Topics

PHP (27) CodeIgniter (22) SQL (4) Facebook (3) HTML (3) Blogger (2) Constructor (2) Destructor (2) Google (2) How to (2) Aadhaar (1) Agent (1) Browser (1) CSS (1) Cakephp (1) Constants (1) India (1) Ip address (1) JS (1) Jquery (1) Meta Tags (1) Robots (1) Scraping Data (1) escape_str (1) htaccess (1) iS mobile (1) javascript (1) mysqli (1)