[Ferret-talk] Find fields beginning with?

[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