SQLite3 (python) query to search multiple columns in one SELECT statement

Question

I'm trying to create an address book and I'd need to check if a given input can be found in all of three columns of the table i created:

conn = sqlite3.connect("Address_Book.db")
c = conn.cursor()

c.execute("""CREATE TABLE addresses (
        name text,
        number text,
        email text)
    """)

    conn.commit()

c.execute("SELECT rowid, * FROM addresses WHERE name LIKE (?)", ('%' + self + '%',))          
res = c.fetchall()

In the above code I'm only searching the 'name' column. I tried writing 'name, number, email' but maybe I don't know the correct syntax and couldn't find it online. I found a way around the problem but it's not that elegant, so I hope someone can help, thank you in advance.

Did you try concatenation name||number||email ?

Yunnosch
– Yunnosch

2020-11-03 18:46:06 +00:00
Commented Nov 3, 2020 at 18:46 — Yunnosch
– Yunnosch, Commented Nov 3, 2020 at 18:46

Dharman · Accepted Answer · 2020-11-03 18:58:39Z

2

A simple workaround for your SQL query would be using the OR operator. As an example, please have a look at the following query

SELECT * from addresses where name LIKE '%A%'
OR number LIKE '%A%'
OR email LIKE '%A%'

edited Nov 3, 2020 at 18:58

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Nov 3, 2020 at 18:52

rahul1205

8941 gold badge8 silver badges14 bronze badges

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

1 Comment

rahul1205 Over a year ago

@Grinch Glad to hear that. Can you please accept my solution as correct, if it works?

Collectives™ on Stack Overflow

SQLite3 (python) query to search multiple columns in one SELECT statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related