help with search engine query

[crazney]

hey,.. i have a field in my database called keywords, for example, it might containt:
"keys keyboard ps2 at qwerty"

then, a user puts into a text field something like:
"querty keyboard"

how could i patch this, over "and" to the field in my database?

i can use "REGEXP querty|keyboard" to match over or, but its a bit slow (and, i want matched over AND)...

any ideas

ps, mysql

David

[shanx24]

David,

SPLIT or EXPLODE the text field like this:

$textField = $HTTP_POST_VARS["searchWords"];
$words = explode($textField, " ");

Now, while composing your SQL, just add these words accordingly...

$sql = "select * from table where 1=1 " ;
$sql .= " and column like '%" . $word[0] . "%'";
$sql .= " and column like '%" . $word[1] . "%'";

Thats should do it, I think?

Cheers
Shanx

[shanx24]

I hoped u caught the gist of my message, but here are corrections..

1. $words[0] and $words[1] in the SQL

2. explode should be like this:

   $words = explode(" ", $textField);

Cheers

[crazney]

yep, did that, worked.. thanks

incase anyone cares:

$kwarray = explode(" ", $keywords);
$SQL_QUERY = "SELECT game_name, game_id, game_working, game_icon FROM games WHERE ";
foreach($kwarray as $thiskey) {
if ($thiskey != "" AND $thiskey != " ")
$SQL_QUERY .= "game_keywords LIKE '%" . $thiskey . "%' AND ";
}

(the "if" is in there to make sure idiots dont go around doing " ke y bo a r d" with lotsa spaces and hence puts load on my db)