开发者

How to add synonym dictionary to mysql FULLTEXT search?

开发者 https://www.devze.com 2023-01-08 03:23 出处:网络
That way if I search for the term \"mens\" the term \"gentlemen\" will match. I tried this: SELECT * FROM cart_product

That way if I search for the term "mens" the term "gentlemen" will match.

I tried this:

SELECT * 
FROM cart_product
WHERE MATCH (
product_name, product_description, product_brand, metal_type, primary_stone, product_type, product_type_sub, product_series, primary_stone_sub
)
AGAINST (
'THESAURUS "english" EXPAND SYNONYM TERM OF "gentlemen"'
)

But that doesn't seem to work. Is this wrong? is there somethig else I h开发者_如何学JAVAave to do with this?

0

精彩评论

暂无评论...
验证码 换一张
取 消