At 01:26 PM 7/13/2011, you wrote:
>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
How about:
select t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.pv+2 and
t1.oid<1000000 order by t2.pv
Mike
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
