pass a list to where clause in Select

[Vinni]

Hi there,

I am making a list of group_id to be searched in a table. Can I pass this list as is to the 'where' clause rather having to iterate the list.

The list of group_id is {23 45 56}

My original SQL looks like:

SELECT t.rootid, t.msgtranslation, t.msgimagepath
from msgcat_root r, msgcat_translation t
where r.group_id = $groupId
and r.rootid = t.rootid
and t.clid = $localeId

can I use it like : where r.group_id = {23 45 56}

thanks

 

[r937]

use IN and parentheses, and make sure the commas are retained

where r.group_id IN (23, 45, 56)

rudy

http://rudy.ca/

 

[Vinni]

Thanks Rudy