How to filter rows data from sqlite table with a variable from multiple column?

Question

Here is the code i am using to filter rows with a variable from single column and Its working:

cur.execute("SELECT * FROM Table1 WHERE item1 LIKE ?", ('%'+item_name+'%', ))
n = cur.fetchall()

But i want to filter rows with one variable from multiple columns. For example: Table has three columns as item1, item2 and item3. I want to filter rows as select * from table1 where item1, item2 and item3. If it is possible, please let me know How to do?

forpas · Accepted Answer · 2020-05-27 12:54:56Z

1

You can join the table to this query:

SELECT '%' || ? || '%' AS item_name

on the conditions that you want, like this:

SELECT t1.* 
FROM Table1 t1 INNER JOIN (SELECT '%' || ? || '%' AS item_name) t2
ON t1.item1 LIKE t2.item_name OR t1.item2 LIKE t2.item_name OR t1.item3 LIKE t2.item_name

and your code will be:

cur.execute("SELECT t1.* FROM .....", (item_name, ))

answered May 27, 2020 at 12:54

forpas

165k10 gold badges51 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

How to filter rows data from sqlite table with a variable from multiple column?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related