android : sqlite using parameter binding for LIKE

Question

My query looks something similar to COL1 = ? AND COL2 LIKE ? OR COL3 LIKE ? OR COL4 LIKE ? ..

and i pass the values of selection args as {"col1value","searchstring", "searchstring","searchstring"}

I am comparing if col2, 3 and 4 with same string . So can i optimize using binding to something like COL1 = ? AND COL2 LIKE ?2 OR COL3 LIKE ?2 OR COL4 LIKE ?2

so that i dont have to repeat the string in arguments {"col1value","searchstring"}

Is this possible and if yes what is the right syntax for it.

Look to stackoverflow.com/a/45284986/7341528 It is more better prntscr.com/fzps8d — Vova
– Vova, Commented Jul 24, 2017 at 21:50

CL. · Accepted Answer · 2017-07-24 16:17:27Z

1

There are many ways of specifying parameters. To (re-)use a specific parameter number, append the number to the ?:

COL1 = ?1 AND (COL2 LIKE ?2 OR COL3 LIKE ?2 OR COL4 LIKE ?2)

(And AND has higher precedence than OR.)

answered Jul 24, 2017 at 16:17

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Comments

Vova · Accepted Answer · 2017-07-24 15:51:31Z

0

Try to this SELECT * FROM table_name WHERE searchstring IN(COL2, COL3, COL4);

In android select :

String select = "? IN (COL2, COL3, COL4)"

select args :

String[] args = new String[] {"searchstring"};

answered Jul 24, 2017 at 15:51

Vova

1,11110 silver badges24 bronze badges

Collectives™ on Stack Overflow

android : sqlite using parameter binding for LIKE

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related