Thanks Jay, but I've been there, and didn't see any examples, so I
wasn't sure how it fit into the other commands. (I'm a little dull today
- too many crisises - crisi? whatever... this week.)
Alex
Jay Sprenkle wrote:
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"
