couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jo Giraerts <whac...@gmail.com>
Subject Re: solving a particular query
Date Tue, 02 Feb 2010 10:51:32 GMT
Thanks for the quick replies! i'm off checking out that route then :)

I temporarily glue the results of various queries together and did some
custom matching in my app, but the more work i can get the db to do, the
better :)



On Tue, Feb 2, 2010 at 11:30 AM, Patrick Barnes <mrtrick@gmail.com> wrote:

> Couchdb does not do fulltext searching itself. (eg for a website's search
> function)
>
> For search, the generally accepted 'best' solution is couchdb-lucene - it
> plugs into couchdb to give you all those nifty matching features.
>
> -Patrick
>
> On 02/02/2010 9:25 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message