Any better ways that LEFT JOIN?

Hi,

My scenario is as described below, and i am in search of a better way to run a query for that scenario. Any bright ideas are more than welcome!

I have a table <keyword> (which contains keyword_id, keyword_trackid, keyword_title) and a table <track> (which contains track_id, track_title). Obviously, i have a number of keywords describing each track.

I need to search for a keyword, and then get all tracks which this keyword describes. However, i also need all other keywords which describes the found tracks. I currently solve this with the following query:

SELECT K1.keyword_id, K1.keyword_trackid, K2.keyword_keyword FROM keyword K1
LEFT JOIN track T1 ON T1.track_id = K1.keyword_trackid
LEFT JOIN keyword K2 ON T1.track_id = K2.keyword_trackid
WHERE (K1.keyword_keyword LIKE '%<keyword>%')";

I am not really worried about full text search right now, as i am more worried about that the query itself most likely will take ages when the number of keywords gets bigger.

I could probably also do this with programming, but then again i would have to get the list of all keywords from the database...which could be something like 5 million keyword - track relations.

So, if you would happen to know how this query can be optimised, then i'd very much appreciate that!