[Ferret-talk] Find fields beginning with?

Mattias Bodlund mattias at oncotype.dk
Mon Jun 30 04:52:15 EDT 2008


It's the same. Will match any word in the field that starts with the  
query. Same as putting a * after the query.

I was looking at a solution where a have a special index that only  
contains the first word of the original field and then do the query like

firstword:dog* and theholefield:dog*

Should only match "dog bone" and not "wild dog".

Just feels a bit strange to have to fields here.

mattias


On 29/06/2008, at 14.52, Henrik wrote:

> Found it!
>
> Ferret :: Search :: PrefixQuery
>
> 29 jun 2008 kl. 14.44 skrev Henrik:
>
>> Ahh true. Interesting situation. Need to research that a bit :)
>>
>> //Henke
>> 28 jun 2008 kl. 10.20 skrev Mattias Bodlund:
>>
>>> But that doesn't  restrict the search to the start of the field.  
>>> dog* will match both "Wild dog" and "Dog bone"
>>>
>>> mattias
>>>
>>> On 27/06/2008, at 23.48, Henrik wrote:
>>>
>>>>
>>>> 27 jun 2008 kl. 15.52 skrev Mattias Bodlund:
>>>>
>>>>> Yes looked at that but the fields I have are often short. The  
>>>>> constrain I'm looking for is that it has to start with the query.
>>>>>
>>>>> Like SELECT * FROM table WHERE title LIKE "term%"
>>>>
>>>> You want to use the WildQuery alternative. That way you can use  
>>>> term*.
>>>>
>>>> Cheers,
>>>>
>>>> Henke
>>>>>
>>>>>
>>>>> mattias
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On 27/06/2008, at 15.47, Jens Kraemer wrote:
>>>>>
>>>>>> On Fri, Jun 27, 2008 at 02:23:39PM +0200, Mattias Bodlund wrote:
>>>>>>> Dens't anyone have some thoughts on this?
>>>>>>
>>>>>> did you have a look at
>>>>>> http://ferret.davebalmain.com/api/classes/Ferret/Search/Spans/SpanNearQuery.html
>>>>>> ? Not sure but it might solve some if not all of your issues.
>>>>>>
>>>>>> cheers,
>>>>>> Jens
>>>>>>
>>>>>>> On 24/06/2008, at 11.33, Mattias Bodlund wrote:
>>>>>>>
>>>>>>>> Is it possible to search for fields that start with a word or  
>>>>>>>> phrase?
>>>>>>>>
>>>>>>>> Lets say I have the following fields:
>>>>>>>>
>>>>>>>> 1 mooning
>>>>>>>> 2 moon landing
>>>>>>>> 3 landing on the moon
>>>>>>>>
>>>>>>>> Then I would like to be able to only get
>>>>>>>>
>>>>>>>> The result I would like to get is:
>>>>>>>>
>>>>>>>> 1 and 2 if I search for moon
>>>>>>>> only 2 if I search for moon landing or moon land
>>>>>>>> only 3 if I search for landing
>>>>>>>>
>>>>>>
>>>>>> -- 
>>>>>> Jens Krämer
>>>>>> webit! Gesellschaft für neue Medien mbH
>>>>>> Schnorrstraße 76 | 01069 Dresden
>>>>>> Telefon +49 351 46766-0 | Telefax +49 351 46766-66
>>>>>> kraemer at webit.de | www.webit.de
>>>>>>
>>>>>> Amtsgericht Dresden | HRB 15422
>>>>>> GF Sven Haubold
>>>>>> _______________________________________________
>>>>>> Ferret-talk mailing list
>>>>>> Ferret-talk at rubyforge.org
>>>>>> http://rubyforge.org/mailman/listinfo/ferret-talk
>>>>>
>>>>> _______________________________________________
>>>>> Ferret-talk mailing list
>>>>> Ferret-talk at rubyforge.org
>>>>> http://rubyforge.org/mailman/listinfo/ferret-talk
>>>>
>>>> _______________________________________________
>>>> Ferret-talk mailing list
>>>> Ferret-talk at rubyforge.org
>>>> http://rubyforge.org/mailman/listinfo/ferret-talk
>>>
>>> _______________________________________________
>>> Ferret-talk mailing list
>>> Ferret-talk at rubyforge.org
>>> http://rubyforge.org/mailman/listinfo/ferret-talk
>>
>> _______________________________________________
>> Ferret-talk mailing list
>> Ferret-talk at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/ferret-talk
>
> _______________________________________________
> Ferret-talk mailing list
> Ferret-talk at rubyforge.org
> http://rubyforge.org/mailman/listinfo/ferret-talk



More information about the Ferret-talk mailing list