LIKE in SQL Lite Python

Question

My Code is :

find = "https://example.com"
sqlite_select_query = "SELECT * FROM 'table' where links LIKE (?)"
c.execute(sqlite_select_query, (find,))

what is the problem? i want when i Select something, Code filter the result for me, when i run this code it returns [] and when im trying to add % at the first and the end like :

"SELECT * FROM 'table' where links LIKE (%?%)"

it gives me an operational error, what should i do to solve this problem?

`c.execute(sqlite_select_query, ('%'+ find + '%',))` – roganjosh Apr 12 '20 at 16:37 — roganjosh, Apr 12 '20 at 16:37
Thank you, Problem solved @roganjosh – Jeremy Hunt Apr 12 '20 at 16:38 — Jeremy Hunt, Apr 12 '20 at 16:38

score 0 · Answer 1 · answered Apr 12 '20 at 16:37

0

You must use the concatenation operator || like this:

find = "https://example.com"
sqlite_select_query = "SELECT * FROM 'table' where links LIKE '%'|| ? || '%'"
c.execute(sqlite_select_query, (find,))

answered Apr 12 '20 at 16:37

forpas

160,666
10
38
76

LIKE in SQL Lite Python

1 Answers1