web2py dal sql 'like' equivalent

Question

Hello everyone i'm wondering if there is a 'like' equivalent in web2py dal.

I would like to do something like this:

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

thank you very much for your help!

Jason

Answer 1

just found my answer

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