[Ferret-talk] Find fields beginning with?

[Henrik]

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