Keywords Or Tags Search

benracer

Hello,
I have an items table which contains a column called keywords. How can i search the table to return the matched tags and in what way would the tags be stored in. At the moment i have tried..

SELECT * FROM items WHERE CONCAT(name,code,keywords) LIKE '%$search%' ORDER BY code ASC

Though it does not return what is in the keywords column's row.

For example if a row contains ...

Name = Red Car
Code = 0001
Keywords = Brand New Wheels

... and the search is "brand new wheels red" nothing is currently returned.

Thanks 😃

leatherback

I think you are looking for the mysql match ... against statement

$query = "select name, match (name,code,keywords) against ($search) as matchvalue from items having matchvalue > 0 order by matchvalue desc";

benracer

Thanks,
This is what i have though i get an error...

$q =explode(" ",trim(mysql_escape_string($q)));

if(strlen($_GET['q']) <= 2){
	include("./includes/header.php");
    echo "<h1>Error:</h1><p>Search querys must be over 3 characters long.</p>";
	include("./includes/footer.php");
	exit();
	}

foreach($q as $search){
	$sql = mysql_query("SELECT name, MATCH(name,code,keywords) AGAINST ($search)");
	}

leatherback

You might want to compare the query I suggested with what you used...

Also, there is no need to explode and all. Have a read in the mysql manual

You do need to sanitize your incoming variables

benracer

Thank you,
Maybe i have been unclear. I have the table items with name and code. How can i add a keywords column and create a search that is like this..

SELECT * FROM items WHERE $q IS IN name, keywords, code

Thanks Ben.

benracer

Okay,

I now have..

foreach($q as $search){
	$sql = mysql_query("SELECT * FROM items WHERE name LIKE \"%$search%\" OR code LIKE \"%$search%\" OR keywords LIKE \"%$search%\"");
	}

Is there a statement "AND OR"?
Thank You, Ben.