OperationalError: no such function: REGEXP
Discussions on Python.org
OperationalError: no such function: REGEXP
I just tried this in sqlite3 command line and it works ! sqlite> .open oewn-plus-2026-sqlite-3.0.1.sqlite sqlite> SELECT COUNT(w.`wordid`) AS `Total` FROM `words` w WHERE w.`word` REGEXP '[0-9]' = 0 AND 1; 151867 So the issue isn’t with SQLite3 but with python ? sql_stmt = """SELECT COUNT(w.`wordid`) AS `Total` FROM `words` w WHERE w.`word` REGEXP '[0-9]' = 0 AND 1;""" self.cursor.execute(sql_stmt) row = self.cursor.fetchone() self.total = row['Total'] print("total: ", self.total) returns A...
0 comments
No comments yet.