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%’)