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
Post Reply