database - 在 couchbase 查询之间

Question

我正在使用 couchbase DB，我写了 namedQuery buy 我遇到了语法错误。我的日期格式:yyMMdd_HHmm

id :XX_YY_0038_2019-03-10@N181025_1636

SELECT meta().id FROM `TABLE_NAME` WHERE meta().id.SUBSTR(23,33) BETWEEN '181025_1650%' AND '181025_1730'
SELECT meta().id FROM `TABLE_NAME` WHERE substr(meta.id(),23,33) BETWEEN '181025_1711' AND '181025_1751'
SELECT meta().id FROM `TABLE_NAME` WHERE meta.id.substr(23,33) BETWEEN '181025_1711' AND '181025_1751' 

应该怎样才是真正的语法

Answer 1

您的问题是 SUBSTR() 函数。这应该有效:

SELECT meta().id 
FROM TABLE_NAME 
WHERE SUBSTR(meta().id, 23) BETWEEN '181025_1650' AND '181025_1730'

您可能需要调整起点 (23)。