Remove Inverted comma from like function in codeigniter 2
If you thinking of sql like functiontry this.
$sql = ('SELECT * FROM datatables_demo WHERE salary::text LIKE ?');$query = $this->db->query($sql, array($value . '%'));
I think in codeigniter2 PostgreSql driver has like operator previous versions codes.If you want to in use codeigniter like function to build query you have to make some change in codeigniter system database libraryI am give you changes in this path
system\database\drivers\postgre\postgre_driver.php
In line no 36
var $_escape_char = '"';Replace with
var $_escape_char = '';Your query output same as you expected o/pBEST OF LUCK