ActiveRecord - like/or_like - how to pass "_" |
[eluser]kezman[/eluser]
Hey everyone! I have a query: Code: SELECT * FROM mytable WHERE myfield LIKE '%text_text%'; I want to use Code: $this->db->or_like($key, $value); But when I pass "_" to $value it is being escaped by CodeIgniter core mysql driver: system/database/drivers/mysql/mysql/mysql_driver.php https://github.com/EllisLab/CodeIgniter/...r.php#L326 Code: // escape LIKE condition wildcards Any help will be appreciated! Thanks in advance!
[eluser]Otemu[/eluser]
Hi, Try this: Quote:$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table http://ellislab.com/codeigniter/user-gui...ecord.html |
Welcome Guest, Not a member yet? Register Sign In |