Re: Help with SQL query construction

2007-12-03 Thread Peter Brawley
Marcus, I've managed to do this with a Perl-DBI script, but would much prefer to do it completely with MySQL instead. You could port it to a recursive stored procedure. It would probably be slower, and what would you have gained? PB Marcus Claesson wrote: Hi! I have a "SQL query constru

RE: Help with SQL query construction

2007-12-03 Thread Jeff Mckeon
> -Original Message- > From: Marcus Claesson [mailto:[EMAIL PROTECTED] > Sent: Monday, December 03, 2007 7:49 AM > To: mysql@lists.mysql.com > Subject: Help with SQL query construction > > Hi! > > I have a "SQL query construction" question that I h

Help with SQL query construction

2007-12-03 Thread Marcus Claesson
Hi! I have a "SQL query construction" question that I hope someone can help me with. After comparing a bunch of DNA fragments (see name below) with a larger reference sequence I get a ordered list ranked according to similarities, and with start/stop co-ordinates where the fragments map to the ref