thank you :-)
On 6月19日, 下午12时20分, Anthony <[email protected]> wrote: > db(db.testtable.name.contains('kate')).select() > > Seehttp://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
