string - Like查询的字符串连接问题

Question

我试图构造这种类型的查询：

SELECT DISTINCT l.accession_key,l.lat, l.lon,l.site, l.location,s.overiew_date FROM g_l AS l INNER JOIN g_s AS s on l.accession_key = s.accession_no WHERE l.lat!=0 AND l.lon!=0 AND l.site='K' AND l.isLive='L' AND l.location LIKE "11%" 

在上面的查询中，“ 11”将来自用户输入，因此我写了这个，但似乎抛出了执行错误，说SQLiteException：“％”附近：语法错误：这是我写的：

var result = this.getRows("SELECT DISTINCT l.accession_key,l.lat, l.lon,l.site, l.location,s.overiew_date FROM g_l AS l INNER JOIN g_s AS s on l.accession_key = s.accession_no WHERE l.lat!=0 AND l.lon!=0 AND l.site='" + options.site + "' AND l.isLive='L' AND l.location LIKE "+ options.locNo+ '%'+"");

Answer 1

也许您缺少引号，请尝试：

LIKE '"+ options.locNo + "%'");

在您的代码末尾。