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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to