How do i get fulltext boolean search to locate results based on partial words. For example i am searching for +protein +bar but i also want results for anything that contains the word bar such as bars
$keywords = $_GET['query'];
// add + to the first keyword
$keywords = '+' . $keywords;
// replace ' ' with ' +' so you add a + to every keyword
$keywords = str_replace(' ', ' +', $keywords);
$query = "SELECT products_id as prodid,
products_name as name,
manufacturers_id as manufacturers_id,
products_price as price,
products_msrp as msrp,
products_date_added as pda,
products_status as status,
products_sku as sku,
products_weight as weight, MATCH(products_name, products_description, products_keywords, products_notes)
AGAINST ('$keywords' IN BOOLEAN MODE) AS score FROM products
WHERE MATCH(products_name, products_description, products_keywords, products_notes)
AGAINST ('$keywords' IN BOOLEAN MODE) ORDER BY score DESC";
$result = mysql_query($query) or die("Error in $query!");
OUTPUT:
SELECT products_id as prodid, products_name as name, manufacturers_id as manufacturers_id, products_price as price, products_msrp as msrp, products_date_added as pda, products_status as status, products_sku as sku, products_weight as weight, MATCH(products_name) AGAINST ('+protein +bar' IN BOOLEAN MODE) AS score FROM products WHERE MATCH(products_name) AGAINST ('+protein +bar' IN BOOLEAN MODE) ORDER BY score ASC