Home | Forums | Couchbase | Couchbase Server 2.0

Similar to SQL "LIKE" statement in Couchbase

2 replies [Last post]
Tue, 03/12/2013 - 11:13
peymankh
Offline
Joined: 03/12/2013
Groups: None

Is this possible in Couchbase??

SELECT * FROM users WHERE user_name LIKE '%john%'.

Seems like I have to use startkey and endkey. But doesn't seem to get the right results.

Also what is the use of startkey_docid? Cause to me it seems like "LIKE '%john'" in SQL but still it doesn't seem to be very satisfactory.

Top
Wed, 03/13/2013 - 01:56
joakimw
Offline
Joined: 09/13/2011
Groups: None

There is no built in support in Couchbase for this. You should probably use a search engine for this, the ElasticSearch integration using the plugin is pretty simple to set up.

Top
Wed, 03/13/2013 - 04:26
peymankh
Offline
Joined: 03/12/2013
Groups: None

Thanks. Installed it, seems descent. Especially for the fact that it has Groovy support.

Top