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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org