web2py dal sql 'like' equivalent

data-access-layer, web2py

Solution

just found my answer

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

Problem

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

Original source