I have tables already. How do I search for a given keyword?
Thanks

Simplest, a normal select or you can use the "like" keyword.
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
However, for more efficient searching you want to create an index, either just a database index (like fulltext, or manually creating the index tables and indexing all columns), or an optimized search index such as an inverted index. http://en.wikipedia.org/wiki/Inverted_index

Note the link to mysql is because the SQLite syntax is the same.

Thanks digital-ether
I will check

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.