[Resolved] Full text search not behaving as it should

Davidc316

Hi ho,
According to the MySQL manual, when you're conducting fulltext searches...

"An asterisk is the truncation operator. Unlike the other operators, it should be appended to the word, not prepended. "

So a search for apple* would return
... apple'',apples'', applesauce'', andapplet''.

(taken from http://www.mysql.com/doc/en/Fulltext_Search.html)

Now, I like the sound of that! My goal is therefore to build a search box and have it so that if someone does a search for (let's say) "camera", then it will also return rows that contain "cameras". So, that's what the aim of the asterisk is.

Anway, the trouble is, I've tried and tried and the asterisk trick simply does NOT work.

PHP:

$query="select from pet where match (petname, pettype, petdescription) against ('$interest in boolean mode')";

See???? I put the asterisk in just like the manual recommended, but I can assure you that does not work. It just behaves as if the * isn't even there and does the searches as normal.

Can anyone help with this?

feldon23

Änd ís MySQL 4 rünníng ön yöür sërvër?

tsinka

Hi,

try this:

$query="select * from pet where match (petname, pettype, petdescription) against ('$interest*' IN BOOLEAN MODE)";

put ' only around $interest*.

Thomas

Davidc316

You're right!

Two days later I've just realised that I am indeed using an older version of MySQL.

AaaaaaaaaaaaaaaarggggggggghHHH!

Ok, thanks for that. I guess it's back to the drawing board for me...