[web2py] Reverse Search with .like

[AsmanCom]

Hi,

here is the important Code from an Sqlite trigger i use very often, is
this possible with web2py to?

Sqlite:
(SELECT table_1.field_1 FROM table_1 WHERE '%' || NEW.field_1 || '%'
LIKE table_1.field_1 )

or i can even do:

(SELECT table_1.field_1 FROM table_1 WHERE '%' || NEW.field_1 || '%'
LIKE  '%' || table_1.field_1  || '%'  )

w2p:
db.person.name.lower().like(‘m%’)