Cool, thanks :-)
On Apr 10, 6:13 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> db(db.name.like('%alex%)).select()
>
> On Apr 10, 4:04 pm, "web2py <<<at>>> technicalbloke.com"
>
> <technicalbl...@googlemail.com> wrote:
> > I can't seem to find a clear example of using 'like' in database
> > selects.
>
> > I'd like to do something like...
>
> > SELECT * FROM `customers` WHERE customer.name LIKE "%alex%" LIMIT 10;
>
> > ...but without resorting to executing the query directly via
> > db.executesql(). The manual says...
>
> > "You can build a query (using operators like ==, !=, <, >, <=, >=,
> > like, belongs) and store the query in a variable q
>
> > >>> q=name=='Alex'"
>
> > ... so I know it's in there but I just don't see how 'like' and
> > 'belongs' fit into that syntax: q=namelike'Alex' makes no sense
> > surely. I'd be very grateful if someone could enlighten me as to the
> > correct grammar.
>
> > Cheers :)
>
> > Roger.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
