Re: search question

2002-09-17 Thread sufcrusher
FULLTEXT index, look in http://www.mysql.com/manual.php Jannes Faber - Original Message - From: "Meltem Demirkus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 10:33 AM Subject: search question > > > > Hi, > > Is there any other efficient way (--exce

Mysql doesn't use datetime index?

2002-09-17 Thread sufcrusher
Hi I have this weird problem, any help is much appreciated. I tried a lot of things and searched in the documentation, etc. but haven't found a solution yet. I have a table 'LogSessions' with a field 'dDateCreation' (datetime type), which has a normal index on it. A simple query like the followi