Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of mrtrick@gmail.com designates
 209.85.218.218 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=QeO391rpWSpbz6ds+IJItu4sd17DFWjJ7KE67cVtXP4uE+N2mzMawrmQFKGBwO90vE
         aDZCLYGAjLqL89GE3IQjhnIZOAGN31989+6zmQ+bN12fMaMxZlAYI6Km7OnnWMzGUKCb
         flZzCWtUaIKcVBDXirt+b5yDMTlx+EGNOfTsM=
MIME-Version: 1.0
In-Reply-To: <39d31cdc1002020224r1e28a5e8yb51e3aee0fb93a35@mail.gmail.com>
References: <39d31cdc1002020224r1e28a5e8yb51e3aee0fb93a35@mail.gmail.com>
Date: Tue, 2 Feb 2010 02:30:27 -0800
Message-ID: <d9b6453f1002020230h604e5b0u2370c16b7370183c@mail.gmail.com>
Subject: Re: solving a particular query
From: Patrick Barnes <mrtrick@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=00032555bc661c72ab047e9b9750

--00032555bc661c72ab047e9b9750
Content-Type: text/plain; charset=ISO-8859-1

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

--00032555bc661c72ab047e9b9750--