sql "like' equivalent

[Jason Solack]

Hello everyone!

I'm wondering if there is a "like" equivalent in the web2py DAL.

I would like to do something like this:

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

thank you in advance for your help.

Jason

[pbreit]

http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#like--regexp--startswith--endswith--contains--upper--lower