db(db.testtable.name.contains('kate')).select()
See
http://web2py.com/book/default/chapter/06#Many-to-Many,-list:<type>,-and-contains
.
Anthony
On Sunday, June 19, 2011 12:10:14 AM UTC-4, hywang wrote:
> db.define_table("testtable",
> Field("name", "list:string")
> )
>
> table contents are as following:
>
> --------------------------------
> id name
> --------------------------------
> 1 ["jim", "kate"]
> -------------------------------
> 2 ["tim", "kate"]
> -------------------------------
> 3 ["tim", "kate", "green"]
> -------------------------------
>
> I want to select rows where name containing "kate", how should I write
> the the sql using DAL ?
>
> thank you
>
