mardi 9 juin 2015

SQLite WHERE-Clause for every column?

Does SQLite offer a way to search every column of a table for a searchkey?

SELECT * FROM table WHERE id LIKE ...

Selects all rows where ... was found in the column id. But instead to only search in the column id, I want to search in every column if the searchstring was found. I believe this does not work:

SELECT * FROM table WHERE * LIKE ...

Is that possible? Or what would be the next easy way?

I use Python 3 to query the SQLite database. Should I go the route to search through the dictionary after the query was executed and data returned?

Aucun commentaire:

Enregistrer un commentaire