Arnaud -
Thanks very much for a suggestion! Unfortunately, when I do that (I'm not much of a
JOIN expert <g>) I end up selecting ALL the rows in the table.
- Ed
-----Original Message-----
From: Arnaud [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 3:19 AM
To: Ed McNierney; mysql List
Subject: Re: Cannot find an index that will be used for SELECT
Hi Ed,
May you could join the table to itself, using a join criteria of index and
position :
SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R1 ON (R1.index=R2.index AND
R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=R3.index AND R3.X>=Left) LEFT
JOIN etc etc...
Does that help?
Arnaud
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
