Can I put an mysql index on a date field with when I use >= or <=?
- by Ryan Detzel
I have indexes for my table user,date, and date,user but when I issue queries like
SELECT * FROM table WHERE date >= '2010-5-1' and user='test';
It doesn't use the date,user index it uses the user index. Is there any way to get mysql to use the date,user index for these queries?