python+SQLiteでlike文 投稿者: utsubo 投稿日: 2017-06-01 in python、SQLiteここを参考に、Asciiの場合 cursor.execute("SELECT * FROM posts WHERE tags LIKE ?", ('%{}%'.format(tag),)) 123 cursor.execute("SELECT * FROM posts WHERE tags LIKE ?", ('%{}%'.format(tag),)) Unicodeの場合tagはunicode string cursor.execute("SELECT * FROM posts WHERE tags LIKE ?", (u"%{}%".format(tag),)) 123 cursor.execute("SELECT * FROM posts WHERE tags LIKE ?", (u"%{}%".format(tag),)) pythonSQLite