MySQL Forums
Forum List  »  Full-Text Search

Full-Text search with join to keyword table
Posted by: Jim Heffernan
Date: September 29, 2017 07:36AM

I have a large inventory file with a fulltext index on the description field. I also have a keyword table with numerous description keywords. I am looking for a fast way to return any records in the inventory file where the description matches against any keyword in the keyword file and we have stock?


The query below does what I am looking for but it is very slow.. is there a way to use a fulltext match against in the join that would speed up the query?


xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

SELECT
p.partno, p.ohqty, p.descriptio , k.key2
FROM
parts p
INNER JOIN keywords2 k ON p.descriptio LIKE CONCAT('%',k.key2,'%')
where ohqty > 0
order by key2

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-Text search with join to keyword table
1865
September 29, 2017 07:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.