DJ Anubis wrote:
Alex Roston a écrit :
Ideally I'd like to do something like:
"UPDATE card SET foo='100' where bar='ABC*';"
Use SQL standard construct:
UPDATE card SET foo='100' WHERE bar LIKE 'ABC%' ;
Excellent. Thank You. My problems are solved!!
Alex
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
I think you mean % not *
% is the wildcard.
-alex
On Jun 13, 2006, at 3:03 PM, Alex Roston 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
Alex Roston a écrit :
> Ideally I'd like to do something like:
>
> "UPDATE card SET foo='100' where bar='ABC*';"
>
Use SQL standard construct:
UPDATE card SET foo='100' WHERE bar LIKE 'ABC%' ;
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
Ok, just found it - sorry...
But this does raise a question, I have UNICODE data, but it says that
LIKE only works correctly (i.e. case-insensitive) on 7-bit data. Can
someone tell me please how to make it work correctly for UNICODE as well
then?
As I read from the docs there, I have to override
6 matches
Mail list logo