This should work
db("'%' || NEW.field_1 || '%' LIKE
table_1.field_1").select(db.table_1.field_1)
On May 7, 9:35 am, AsmanCom <[email protected]> wrote:
> 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%’)
