sql - How to: match (search space) against (join with column from other table) -


I am poor at SQL queries so it can be a stupid question. However, here's what I would like to do:

Corpuses the table // I want to search through title body ...

Table search / The list of search terms to apply the word keywords ... ...

The query I want to write is more or less: I think I need some sort of One join, but I'm not sure how to do this. In addition, I'm not sure that anything against the operator will be taken literally - docs has not been mentioned in any way.

Select * Corpuses where against the match (title, body) (choose words from searches);

I am using MySQL 5

Any idea is highly appreciated.

Thank you! Brian

Looks like you want to use a full match matching expression in your inclusive condition.

I have never used full text matches in a single condition, so I'm not sure this will work, but hypothetically it can do this:

  Select c. * Search against c corpuses c (STMM) (STIT, c.  

OK I have some definitions from your table definitions and MySQL manual Here's a query that works (Testing with MySQL 5.1.30): Select from

  from where to match (title, entity) (from (SELECT GROUP_CONCAT (from the term SEPARATOR '') searches) IN boolean mode);  

Comments