dear Dennis thank u 4 reply once more, i'll try with your suggestion
vl Dennis Cote wrote: > > 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 > > -- View this message in context: http://www.nabble.com/newB-question--c%2B%2B-and-sqlite3--how2-check-if-word-exist-in-the-table-tp15758100p15823325.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users