How to use '?' wildcard ?
nome ="test"
cursor = db.execute("SELECT id FROM marca WHERE nome LIKE ?",('%'+nome))
Thank
Asked
Active
Viewed 29 times
0
Alberto M
- 23
- 1
- 6
-
The `?` is a parameter marker, the `%` is the wildcard. – jarlh Feb 26 '21 at 08:21
-
@ruohola, which dbms has `?` for single character?!? ANSI/ISO SQL has `_`, underscore. – jarlh Feb 26 '21 at 08:37
-
@jarlh Ah :D only MS Access :DDDDD – ruohola Feb 26 '21 at 08:39
-
I searched for it before to ask , Thanks . Link useful. I want just ask what ':s' means here `pattern = "%"+nome+"%" cursor = db.execute("SELECT id FROM marca WHERE nome like :s",{"s":pattern})` – Alberto M Feb 26 '21 at 08:49