MySQL table/join query time update

Just wanted to mention (for anyone who had attempted to help me sort
out my query problem a little while back on the big tables) that it
seems I've found my gremlin. I did have indexes set up... for
everything except the part that mattered the most. :)  I created an
index for the ID value that let the three tables be matched, in each
table, and now it burns right along like I'd hoped it would. The
problem wasn't in finding matches for keywords, but in finding the ID
value when joining.

SELECT * FROM master,track WHERE master.Title="TextHere" AND
  track.TrackTitle LIKE "%John%" AND master.ID=track.masterID;

It was that last part that was slugging things up.
                         
~ Nathan Lyle (The U.P. Web Maestro)
 
     Web: www.upwebmaestro.com  E-Mail: nathan(at)upwebmaestro.com     
     Phone: (906)485-4806

    "... one of the main causes of the fall of the Roman Empire 
     was that, lacking zero, they had no way to indicate successful 
     termination of their C programs." - Robert Firth.

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA