On 6/13/06, Alex Roston <[EMAIL PROTECTED]> wrote:
Does SQLite have anything resembling a wildcard function? I need to either get rid or modify a whole group of rows which have some common elements in the primary key.Ideally I'd like to do something like: "UPDATE card SET foo='100' where bar='ABC*';"
see this page: http://sqlite.org/lang_expr.html look at "LIKE"