Re: Problem with index

2002-05-23 Thread [EMAIL PROTECTED]
> Hi, I have a Mysql database with one Master and one slave > I have a problem with the following table "session": > +--+-+--+-+-+---+ > | Field | Type | Null | > Key | Default | Extra | > +---

RE: Problem with index, where clause and order by

2002-03-28 Thread Michael C. Neel
You can try to force an index with: SELECT * FROM Posts USE INDEX(index4) WHERE Board = 'board1' ORDER BY Board DESC, Number DESC Mike -Original Message- From: Michael Bonfert [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:06 AM To: [EMAIL PROTECTED] Subject: Problem w