incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Metin Akat <akat.me...@gmail.com>
Subject Re: solving a particular query
Date Tue, 02 Feb 2010 10:27:49 GMT
The best way to this so far is to use a full text search engine.
Have a look at couchdb-lucene

On Tue, Feb 2, 2010 at 12:24 PM, Jo Giraerts <whachoe@gmail.com> wrote:
> Hi,
>
> I'm just starting with couchdb and have been reading up on views. Most of
> the queries i want to do, i can get done with simple views, but 1 seems to
> escape me.
>
> I want to do something like this: SELECT * FROM blogposts WHERE title LIKE
> '%searchterm%' OR author LIKE '%searchterm%' OR body LIKE '%searchterm%'
>
> Is there a way to do this with views or should i resort to querying multiple
> views and combining the resultsets mysql?
>
>
> Thanks,
>
> Jo Giraerts
>

Mime
View raw message