I have an "IN()" list of 107 IDs (PK) out of about 6000 possible.
I do this query and I get 105 rows back. I want to know which two [107 - 105 = 2] of the IDs in the "IN()" list are absent? # 105 rows SELECT count(*) FROM mytable WHERE id IN (11704, 10144, 11842, 11299, 11192, 11563, 11378, 10343, 10752, 10626, 11916, 11456, 11813, 11337, 10219, 11356, 11800, 10243, 10251, 11357, 11353, 11267, 12110, 200044, 11875, 11060, 10233, 10865, 10264, 10857, 10659, 10266, 10987, 11317, 11868, 10858, 11087, 11088, 10260, 11321, 11350, 10247, 10258, 10248, 11232, 10588, 11086, 11828, 10055, 11347, 10278, 11349, 10261, 11499, 11351, 11316, 12284, 12240, 12265, 11340, 10708, 11041, 11853, 12255, 11507, 11788, 10067, 10888, 11875, 11333, 10867, 10938, 11030, 10654, 10538, 10918, 11068, 11237, 11060, 10127, 10495, 10035, 10294, 10173, 10098, 10282, 10383, 10049, 10076, 10277, 10106, 10541, 10176, 10131, 10252, 11051, 11152, 11932, 11318, 10886, 10605, 10029, 11857, 10549, 10329, 11510, 10539); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
