android - 如何在 SQLite 中为多列使用 MATCH 关键字？

Question

我使用 fts3 创建了一个表。我使用以下查询来获得结果

      String query = "SELECT "+ID+" as _id," + 
        NAME +  
        " from " + TABLENAME +
        " where " +  NAME + " MATCH '" + inputKeyword + "';";
        Log.w(TAG, query);

根据 inputKeyword 给出名称列表。

但它不适用于多列，

    String query = "SELECT "+ID+" as _id," + 
        NAME +  
        " from " + TABLENAME +
        " where " +  NAME + " MATCH '" + inputKeyword + "' AND "+ EMAILADDRESS + " MATCH '"+emailaddress+"';";

它没有给出任何结果，还说您不能在此查询中使用 MATCH。如何做到这一点？

Answer 1

您的查询如下所示:

SELECT ID as _id, Name
FROM TableName
WHERE Name MATCH 'xxx' AND EmailAddress'yyy'

第二列缺少 MATCH 运算符。你想要的应该是这样的:

SELECT ID as _id, Name
FROM TableName
WHERE TableName MATCH 'Name:xxx EmailAddress:yyy'