搜索多列SQLite中选择FROM [英] Search multiple columns in sqlite SELECT FROM

问题描述

我用这个code搜索栏A.我应该做哪些修改，如果我要搜索列A和B列同步？

I use this code to search for Column A. What modification should I make if I want to search Column A and Column B simultaneously?

String sql = "SELECT * FROM " + TABLE_NAME +
                " WHERE " + ColumnA + " LIKE ? ORDER BY " + ColumnA + " LIMIT 100";

我已经试过这一点，但它不工作：

I've tried this but it's not work:

String sql = "SELECT * FROM " + TABLE_NAME +
                " WHERE " + ColumnA + " LIKE ? ORDER BY " + ColumnA + " LIMIT 100 OR SELECT * FROM " + TABLE_NAME +
                " WHERE " + ColumnB + " LIKE ? ORDER BY " + ColumnB + " LIMIT 100";

任何错误，我做？

Any mistake I made?

推荐答案

您可以使用或连接两个EX pressions。 但是，这两个必须是完整的EX pressions：

You can use OR to connect two expressions. However, both must be complete expressions:

SELECT ... WHERE ColA LIKE ? OR ColB LIKE ? ...

这篇关于搜索多列SQLite中选择FROM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！