Hello
Is there a way when searching for a range of values for a particular field that mysql would not have to look at the entire table ... I'm guessing with some type of composite key or something? ...
e.g.
SELECT aField FROM aDatabase WHERE aVariable BETWEEN field1 AND field2;
Field1 and field2 are indexed but that doesn't help because you're looking for a range of values instead of a particular value
Rob,
I'm having a hard time wrapping my head around your example.It's like the tail wagging the dog.<g>
Putting variables and columns to your syntax I get:
select cust_num from table_invoices where 5 between invoice_amt and tax;
I think you meant to say:
select aCol from aTable where aCol between val1 and val2;
If aCol is indexed, then MySQL will use the index to get a Range on val1 and val2. Just use "Explain" and you'll see the index that it's using.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
