> ËÁË ÌÕÞÛÅ ÐÉÓÁÔØ × ÐÏÌÅ ip2 ÄÉÁÐÁÚÏÎ, ÞÔÏÂÙ ÐÏÔÏÍ ÚÁÐÒÏÓ > "ÐÏÌÕÞÉÔØ ×ÓÅ ÓÔÒÏËÉ ÔÁÂÌÉÃÙ1 ÇÄÅ ip ÎÅ ÐÏÐÁÄÁÅÔ × ÓÐÉÓÏË ÉÚ ÔÁÂÌÉÃÙ2" > ×ÙÐÏÌÎÑÌÓÑ ÂÙÓÔÒÏ.
IMHO, 1) ÎÁÄÏ ÐÏÐÒÏÂÏ×ÁÔØ ÈÒÁÎÅÎÉÔØ IP × ÃÅÌÏÞÉÓÌÅÎÎÏÍ ÔÉÐÅ ×ÍÅÓÔÏ/× ÄÏÐÏÌÎÅÎÉÅ Ë varchar ÉÍÅÎÎÏ ÄÌÑ ÓËÏÒÏÓÔÉ. 2) ÔÏÇÄÁ ÄÌÑ ÄÉÁÐÁÚÏÎÁ ÎÁÄÏ ÉÓÐÏÌØÚÏ×ÁÔØ Ä×Á ÞÉÓÌÁ. ÐÒÉÞÅÍ ÅÓÌÉ ÜÔÏ ÎÅ ÄÉÁÐÁÚÏÎ, Á ÏÄÉÎ ÁÄÒÅÓ, ÔÏÇÄÁ ÎÁÞÁÌÏ=ÏËÏÎÞÁÎÉÅ=ÏÄÉÎ ÁÄÒÅÓ É ÚÁÐÒÏÓ ÂÕÄÅÔ ÏÂÙÞÎÙÍ: NOT EXISTS ... FROM t2 ... WHERE t1.IP BETWEEN t2.beginIP AND t2.endIP