mysql query question

Hello Here is the query i want to run select * from TABLEA where chipid in('1873031558') and chip_section in('A')  but with multiple values of chipid and its corresponding chip_section values (i have about 3000 of them) select * from TABLEA where chipid in('1873031558', '1887262626') and chip_section in('A','A') so the result should return only the rows which satisfy the AND condition (1st chipid with 1st chip_section) , (2nd chipd with 2nd chip_section) BUt, the result just returns all rows which match chipid and ignores the chip_section.
 
Is this something that needs to be run as a loop using a stored procedure?
 
 
 
 
-K
_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008