Re: Most Efficient Query

On Thu, 22 Jul 2004 17:44, Monty wrote: > I'm writing a simple search script in PHP and wasn't sure whether the best > way to search for the records in MySQL was this way... > > SELECT * FROM db WHERE field1 LIKE "var%" OR field2 LIKE "var%" ... > > ...or would it be faster and more efficient to use fulltext indexes with > MATCH() and AGAINST()? I have MySQL 3.23.58 installed on my server. > > Thanks! Depends what you want to do - for instance fulltext search IIRC does not support substring searches. -- David Robley I Have To Stop Now, My Fingers Are Getting Hoarse!