RethinkDB case insensitive query in python

Connect to the database:

import rethinkdb as r
r.connect("127.0.0.1", 28015).repl()
db = r.db("search")

Filter using match:

table.filter(r.row["Url"].match("(?i).*\.PDF$")).count().run()

Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire string.

Leave a Reply

Your email address will not be published. Required fields are marked *