[Ferret-talk] Find fields beginning with?

[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%"

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