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
