using three words in one table and finding/match them in any order in another table

[0o0o0]

how would i make a query that finds in one table title is.. Georgia Drag Racing, and match with another table that may have a title that says drag racing in georgia mustang vs dodge. Both under title two different tables.

how can you find and match these two?? ( basically using the first one which has the three main words I need... to find the match or matchs of the three words in the title(s) in the other tables... entries.

etc etc.. kentucky drag strip

other table title may be.. drag strip mustang stalls at start in kentucky

Get me?
thanks if you can give an example or the command I need for this

[0o0o0]

ok I kinda described that confusing ...

Ok you have one table.. with TITLE...

and another with TITLE...

so say you have Pirates of Caribbean in both tables.. and you want to match table 1 where table two says Pirates of Caribbean..

simple right?? what if tabke two didnt have the identical title as table 1.. and it was Pirates of the Caribbean, The

now what?? how would you do it to make table 1's title look for only the 4 fours in table two... without the ,the

remember I want to do this for 1000's of titles.. but make table 1 the actual title "words" im searching for in table 2.

[Derokorian]

Why not have a Titles table, and use the current columns as foreign keys to that table (so that they are a number relating to a primary key for example) that way you're not storing duplicate data, and a simple join where titleId=titleid would get you what you're looking for. Also you wouldn't have multiple places to update should you need to rename a title.

[0o0o0]

automation.. it will be completely handsfree.

Im looking at explode.. we'll see.