like and likep differences

Post Reply
gary.gabriel
Posts: 8
Joined: Thu Mar 14, 2002 1:42 pm

like and likep differences

Post by gary.gabriel »

I have the following metamorph query:

+honda "fuel cell" electric @0

which according the the manual means

(honda AND ("fuel cell" OR electric))

this works fine when i use it with 'like':

select story_id from story where text like '+honda "fuel cell" electric @0';

however i also want relevance ranking, so i'm using likep:

select story_id,$rank from story where text likep '+honda "fuel cell" electric @0';

with likep, i get back a story that just contains 'honda' in it, and no mention of either electric or "fuel cell". doesn't the metamorph syntax say that the above query should only match documents which contained at least one of ("fuel cell", electric) in addition to honda?

Thanks.

-Gary
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

like and likep differences

Post by John »

LIKEP does relevance ranking, and can return documents that are not exact matches, and will show a lower rank. You can "set likepobeyintersects=1" to make LIKEP respect the intersects that you specify.
John Turnbull
Thunderstone Software
Post Reply