The || operator is "concatenate", its like + in python.
On 7 Mai, 16:48, Mengu <whalb...@gmail.com> wrote: > is || just a string or have any purpose? > > On 7 Mayıs, 17:35, AsmanCom <d.as...@web.de> 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%’)