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
+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