≈ the.bay.news

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

Sign in to join the discussion — your thebay.events account works here.

No comments yet.