See
http://web2py.com/books/default/chapter/29/06#like,-regexp,-startswith,-contains,-upper,-lower
.
Anthony
On Saturday, April 20, 2013 6:26:14 PM UTC-4, BlueShadow wrote:
>
> I got a table like this one:
> db.define_table('Movie',
> Field('Title',length=64),
> Field('Content',length=512),
> )
> Now I like to search this table Title with a string like "Star Wars".
> My problem is that there are 6 Star Wars Movies: Star Wars: Episode I...
> I want to have all of those 6 as a result.
> any idea how I can do that?
> My first attempt failed miserable
> Movies=db(db.Movie.Title[:len(Searchstr)]==Searchstr)
> which gives me this: Set (SUBSTR(Movie.Title,1,(2 - 1)) = '2')
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
