[web2py] Re: query with contains ....

On Friday, December 29, 2017 at 12:50:24 PM UTC-8, Dave S wrote: > > > > On Friday, December 29, 2017 at 6:16:04 AM UTC-8, Anthony wrote: >> >> You could do something like: >> >> query = (db.mytable.myfield.like('mytext,%') |# First item in list >>

[web2py] Re: query with contains ....

On Friday, December 29, 2017 at 6:16:04 AM UTC-8, Anthony wrote: > > You could do something like: > > query = (db.mytable.myfield.like('mytext,%') |# First item in list > db.mytable.myfield.like('%,mytext,%') | # Neither first nor > last item >

[web2py] Re: query with contains ....

You could do something like: query = (db.mytable.myfield.like('mytext,%') |# First item in list db.mytable.myfield.like('%,mytext,%') | # Neither first nor last item db.mytable.myfield.like('%,mytext') |# Last item in list db.mytable.myfield.like('mytext'))