Hi, Also If I run a like query "select * from product_keyword where keyword like '%aries%'" I get zero results. But in site I got 9 results.
I am bit confuse how search is actually working in ofbiz. Regards, Abhishake On Tue, Aug 11, 2009 at 10:37 PM, Abhishake Agarwal < [email protected]> wrote: > Thanks Scott, > > Is there any way to make EQUAL query i.e (Exact keyword match) > > Regards, > Abhishake > > > > > On Tue, Aug 11, 2009 at 8:47 PM, Scott Gray <[email protected]>wrote: > >> It's a LIKE query so it will return keywords containing aries such as >> diaries. >> >> Regards >> Scott >> >> HotWax Media >> http://www.hotwaxmedia.com >> >> >> On 12/08/2009, at 3:02 AM, Abhishake Agarwal wrote: >> >> Hi, >>> >>> I facing an issue related to search which I found to be similar in >>> http://demo.ofbiz.org/ecommerce. >>> >>> When I search a word 'aries' on demo site I got nine search results. But >>> If >>> I look at ProductKeyword table there is no entry for keyword 'aries'. >>> >>> Also if you search 'aries1' then it gives 'no result found' which is >>> correct. >>> >>> Please let me know what is missing. >>> >>> Regards, >>> Abhishake >>> >> >> >
