Quotes in query

[eluser]ivantcholakov[/eluser]

Code:

// Tested on CodeIgniter 3.0-dev

$table = 'table';
$name = 'John';
$zip_codes = array('0000', '0001', '0002');

echo $this->db
    ->select()
    ->from($table)
    ->where_in('Zipcode', $zip_codes)
    ->like('name', $name)
    ->get_compiled_select();

/*

Result query text:

SELECT *
FROM `table`
WHERE `Zipcode` IN('0000', '0001', '0002')
AND  `name` LIKE '%John%' ESCAPE '!'

*/