RethinkDB filter by regular expression 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(".*\.pdf$")).run()

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