[Ferret-talk] Find fields beginning with?

Henrik henke at mac.se
Sun Jun 29 08:44:40 EDT 2008


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



More information about the Ferret-talk mailing list