Is it possible priority of search in mysql Full text search

yes, it is possible priority of search in mysql  Full text search.we can define priority of search by adding + and – before search phrase in boolean mode

+ means include that word

– means Excluding  that word

For E.g  SELECT * FROM product_table WHERE MATCH (column1, column2) AGAINST (‘”+mobile -charger”‘ IN BOOLEAN MODE);

it will only search for only mobiles in db , if it find  “mobile charger ” it will skip that row.This way we can add priority of search in Full text search of MySQL.

Leave a Reply

Your email address will not be published. Required fields are marked *