SQLite Query Multiple Column Search

Question

I have a SQLite database which I would like to search two columns with one word (from a variable)

Currently I have the below code & query...

selection = locTextBox.get()
    cursor.execute("SELECT * FROM depot_racks WHERE rack OR floorzone LIKE '%' || ? || '%'", (selection,))
    for row in cursor.fetchall():
        dataArea.insert("", tk.END, values=row)

When the variable is empty it returns all results which is correct, when the variable is set to FZ1 it returns items found in the floor zone column but if the variable contains RACK1 then it returns nothing from the rack column.

The variable is set via a combobox which the user selects from (either RACK1, RACK2 etc or FZ1, FZ2 etc)

The query is obviously wrong in some way I just cannot figure it out, any help is appreciated!

Michael Butscher · Accepted Answer · 2020-10-20 21:58:30Z

2

The OR is not associative like a "+" in arithmetic so you have to repeat the whole LIKE part.

cursor.execute("SELECT * FROM depot_racks WHERE rack LIKE '%' || ? || '%' OR floorzone LIKE '%' || ? || '%'", (selection, selection))

answered Oct 20, 2020 at 21:58

Michael Butscher

11k4 gold badges28 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

SQLite Query Multiple Column Search

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