RE: fulltext searching and query order question

2003-06-13 Thread H M Kunzmann
ards, > Mike Hillyer > www.vbmysql.com > > > -Original Message- > From: H M Kunzmann [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2003 10:33 AM > To: [EMAIL PROTECTED] > Subject: fulltext searching and query order question > > > > Hi all. >

RE: fulltext searching and query order question

2003-06-13 Thread Mike Hillyer
('word1 word2' in boolean mode) order by field1,field2,field3 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: H M Kunzmann [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:33 AM To: [EMAIL PROTECTED] Subject: fulltext searching and query order question Hi

fulltext searching and query order question

2003-06-13 Thread H M Kunzmann
Hi all. I have a fulltext index on a table. If I have the following fields: field1,field2,field3,field4 Field4 being the fulltext field. I have the following indices: index1->field1,field2,field3 index2->fulltext field4 If I do a select: select * from table where match(index2) aga