another multi word search

acemods

I bet you guys are sick of seeing this type of thread but i cant find the answer im looking for.

the query im using just now is as bellow

$for = str_replace(" ","|",$search); 
$sql = "SELECT * FROM barcode WHERE (part REGEXP '$for') OR (description REGEXP '$for')"; 
$result = $db->query($sql);

example database is

code description
AC0013 LAMP TABLE SILVER SMALL
AC0008 BROOKLYN OAK NEST OF TABLES

if i search for "nest table" i will get the 2 results from about. how do i change my query so it would only display AC0008 BROOKLYN OAK NEST OF TABLES in aswell as me still being able to search my part.

this would need to work for searching with more than 2 words aswell.

Tia

Acemods

leatherback

You could have a look at match ... against select statements, which will match any number of columns, against a space-separated string of words, and return a match-value. Very useful if you want full-text, best match ordered searched.

acemods

I have had a look at using MATCH and AGAINST but im having problems as its not pulling everything from the table.

my script is

$for = str_replace(" ","+",$search); 
$sql = "SELECT * FROM barcode WHERE MATCH (description) AGAINST ('$for' IN BOOLEAN MODE)";

when i search for nest table i will only get 6 record even though i have 47 records that contain both nest and table. does anybody see where im going wrong.

Acemods

acemods

got my search working now. please see my code bellow. if anybody can think of a better way to come up with it please post example to help me and others.

$for = str_replace(" ","* +",$search); 
$sql = "SELECT * FROM barcode WHERE MATCH (part,description) AGAINST ('+$for*' in boolean mode)"; 
$result = $db->query($sql);

acemods