如题,比如我实现如下拼接
for (Object key : key_values){
WHERE("(article.title LIKE '%"+key.toString()+"%' OR article.content LIKE '%"+key.toString()+"%')");
}
SQL 输出如下 中间链接为AND
SELECT user.nickname,user.userIcon,article.*
FROM article,user
WHERE (user.openID = article.openID)
AND ((article.title LIKE '%sql%' OR article.content LIKE '%sql%') AND (article.title LIKE '%啊%' OR article.content LIKE '%啊%'))
而我想要的是如下结果,中间链接为OR
SELECT user.nickname,user.userIcon,article.*
FROM article,user
WHERE (user.openID = article.openID)
AND ((article.title LIKE '%sql%' OR article.content LIKE '%sql%') OR (article.title LIKE '%啊%' OR article.content LIKE '%啊%'))