SQL IN operator

[milantrax]

Is it possible something like this, with IN operator:
SELECT * FROM Customers WHERE City IN ('Paris','London');
Thanks

[noncent]

Hi Milantrax,

Yes, you can use IN like below sample code with pdoQuery:

/**
 *  Query with IN operator 
 */
$q = $db->pdoQuery('SELECT * FROM Customers WHERE City IN (?, ?);',array('Paris','London'))->showQuery()->results();
// print array result
$helper->PA($q); 

Sorry for any mistake's actually I am out for my weekend, so its just quick reply by my cell phone.

Cheers!!!