Quotes in query

[eluser]ZioN[/eluser]
Hi,

I'm working on a project and I need to use a query to search for a name(can be left blank) and multiple zipcodes.

I need to produce this:

Code:

SELECT * FROM (`TABLE`) WHERE `name` like '%%' and Zipcode ('0000', '0001', '0002')

This way it works. This is the code I use:

Code:

$this->db->select('*');
$this->db->from('TABLE');
$this->db->where_in('Zipcode', $var);

this produces:

Code:

SELECT * FROM (`TABLE`) WHERE `Zipcode` IN ('0000,0001,0002') and `name` LIKE '%%'

If I try to test the codeigniter query by setting the zipcodes in an variable manually like this:

$string = '0000', '0001'
codeigniter is producing \'0000\', \'0001\'

I've been lurking the user guide for answers already but without result.

Thanks!