how to make searching queries using sqlite database

Question

My question is about how to make searching query with two option. for example search by name and by keyword with sqlite database in android. can i make two tables for name and keyword or just one table?

Can you Please provide for which tables you want to make queries and what you want to search ? — Chintak Patel
– Chintak Patel, Commented Mar 19, 2018 at 6:03
You need to check this example : androidhive.info/2013/09/… — Adil
– Adil, Commented Mar 19, 2018 at 7:00
in my application i've made two tables.. one tbl_books and the others tbl_title_book and in searching queries i have two option for search.. 1.search by title book and 2.search by keyword — Gerald Wenas
– Gerald Wenas, Commented Mar 19, 2018 at 7:01

Gokul Nath KP · Accepted Answer · 2018-03-19 06:08:11Z

1

Something like this should work:

Cursor cusror = db.rawQuery("SELECT * FROM " + TABLE_A + " WHERE " + column_1_id + " = " + col_1_value + " AND " + column_2_id + " = " + col_2_value);

In your case, one table should be enough with name and keyword as column. Modify above query as required, like below.

column_1_id -> name
column_2_id -> keyword

answered Mar 19, 2018 at 6:08

Gokul Nath KP

15.6k25 gold badges94 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gerald Wenas Over a year ago

what is the function of col_1_value??

user4571931 · Accepted Answer · 2018-03-19 07:21:45Z

0

you can make single table and insert record when you search that time fire sql search query like below ..

        String selectQuery = "SELECT  * FROM " + MY_ITEMS_TABLE_NAME + " WHERE name=" + namevalue +", keyword=" +keywordvalue;
    Cursor c = db.rawQuery(selectQuery, null);

answered Mar 19, 2018 at 7:21

user4571931

Collectives™ on Stack Overflow

how to make searching queries using sqlite database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related