From: Elim Qiu Date: July 13 2011 6:26pm Subject: query for twin primes List-Archive: http://lists.mysql.com/mysql/225371 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 I have a prime table +-----+------+---------+ | oid | pv | descipt | +-----+------+---------+ | 1 | 2 | NULL | | 2 | 3 | NULL | | 3 | 5 | NULL | | 4 | 7 | NULL | | 5 | 11 | NULL | | ..................... | +-----+------+---------+ what the query will be if i like to find all rows where pv+2's are also in colum 'pv', where oid < 1000000? In other words, how to get the list of yonger brother of the twin primes within certain bound? Thanks