Hello,
I am trying to write a query that will perform the following -
Full text Search for a word in a table called 'db', code as follows -
"SELECT id, url, title,
MATCH(url, title)
AGAINST ('".$word."') AS score FROM db
WHERE MATCH(url, title)
AGAINST ('".$word."') ORDER BY score DESC";
but then I have another table called 'link'. It has 2 columns 'url' and 'urltwo'. For each URL that is found in the above SELECT statement I want to search for it in the 'URL' column of the 'link' table. HOWEVER I only want to return the results where the 'urltwo' column ALSO equals ANY one of the URL's found in the above SELECT statement.
Complex I know,
Any feedback would be appreciated.
