Web2py dal sql 'like' equivalent

Question

Hi everyone, I am wondering if there is an equivalent in web2py dal.

I would like to do something like this:

db().select(db.person.name like 'JA')

Thank you so much for your help!

Jason

Answer 1

just found my answer

db().select(db.person.name.like('JA%'))