开发者

Mysql FullText Not returning results

开发者 https://www.devze.com 2023-04-12 20:27 出处:网络
I have a query that is supposed to search from the db and return the most closely matching results. Problem is it is just returning results having a single word.

I have a query that is supposed to search from the db and return the most closely matching results.

Problem is it is just returning results having a single word. I'm using full-text search in binary mode.

The query is as below:

select * from category
where CategoryActive='Y' 
      AND labelCategory != '1' 
      and labelCat开发者_StackOverflowegory != '' 
      and labelCategory != '2' 
      and (labelCategory like '%inkjet%' 
      or labelCategory like '%laser%') 
      and Match (CategoryID, CategoryName,CategoryFeedName,
                 CategoryDescription, CategorySEOTitle,
                 CategorySEPDescription, CategorySEPKeywords) 
          Against('$value' IN BOOLEAN MODE)
order by `CategoryName` asc;

Please make a suggestion or indicate the mistakes in the query above.

0

精彩评论

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

关注公众号