[Ferret-talk] Find fields beginning with?

[Mattias Bodlund]

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

Is it possible with ferret or would a simple SQL query do this better?

Cheers
Mattias