如何在sqlite中使用占位符执行SELECT * LIKE语句? [英] How to execute SELECT * LIKE statement with a placeholder in sqlite?

问题描述

我有一个参数 tag 并且我是这样执行的:

I've got an argument tag and I perfomed this way:

cursor.execute("SELECT * FROM posts WHERE tags LIKE '%?%'", (tag,))

但它似乎不起作用.
我是 sqlite 的新手，请告诉我如何修复它.谢谢！

but it doesn't seem to work.
I'm new to sqlite, please tell me how to fix it. Thx !

推荐答案

将通配符应用于参数，而不是 SQL:

Apply the wildcards to the parameter, not the SQL:

cursor.execute("SELECT * FROM posts WHERE tags LIKE ?", (f'%{tag}%',))

? SQL 参数插值为您添加了引用，因此您的查询最终为 '%'value'%'，这不是有效的 SQL.

The ? SQL parameter interpolation adds quoting for you, so your query ends up as '%'value'%', which is not valid SQL.

这篇关于如何在sqlite中使用占位符执行SELECT * LIKE语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！