[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] newB question; c++ and sqlite3;
From:       Dennis Cote <dennis.cote () gmail ! com>
Date:       2008-02-29 16:53:15
Message-ID: 47C8387B.2070900 () gmail ! com
[Download RAW message or body]

vl.pavlov wrote:
> 
> i wander how 2 check (efficiently) if some word (string, in c++) exist in
> the sqlite3 table 
> 

Assuming this is the same database as your last question. You have the 
table:

    create table words (word text primary key, number integer);

Then this query will work:

    select exists (select * from words where word = :word);

HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]