我用这个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 ? ...